<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>Voya Media: Database.cs Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
</script>


</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">Voya Media
   &#160;<span id="projectnumber">1.2.255.1212</span>
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.8.0 -->
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="namespaces.html"><span>Namespaces</span></a></li>
      <li><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>Globals</span></a></li>
    </ul>
  </div>
</div>
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
  initNavTree('a00012.html','');
</script>
<div id="doc-content">
<div class="header">
  <div class="headertitle">
<div class="title">Database.cs</div>  </div>
</div><!--header-->
<div class="contents">
<a href="a00012.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 ﻿using System;
<a name="l00002"></a>00002 <span class="keyword">using</span> System.IO;
<a name="l00003"></a>00003 <span class="keyword">using</span> System.Collections;
<a name="l00004"></a>00004 <span class="keyword">using</span> System.Collections.Generic;
<a name="l00005"></a>00005 <span class="keyword">using</span> System.Data;
<a name="l00006"></a>00006 <span class="keyword">using</span> System.Data.SqlServerCe;
<a name="l00007"></a>00007 <span class="keyword">using</span> System.Diagnostics;
<a name="l00008"></a>00008 <span class="keyword">using</span> System.Net;
<a name="l00009"></a>00009 <span class="keyword">using</span> System.Reflection;
<a name="l00010"></a>00010 <span class="keyword">using</span> System.Resources;
<a name="l00011"></a>00011 <span class="keyword">using</span> System.Text;
<a name="l00012"></a>00012 <span class="keyword">using</span> System.Text.RegularExpressions;
<a name="l00013"></a>00013 
<a name="l00014"></a><a class="code" href="a00024.html">00014</a> <span class="keyword">namespace </span>Database
<a name="l00015"></a>00015 {
<a name="l00021"></a><a class="code" href="a00011.html">00021</a>     <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="a00011.html" title="Performs SQL queries with the Database. Supports inserting, updating, deleting and retrieving data...">SQL</a>
<a name="l00022"></a>00022     {
<a name="l00023"></a>00023         <span class="comment">// Define private member properties.</span>
<a name="l00024"></a>00024         <span class="keyword">private</span> ResourceManager             resourceManager = <span class="keyword">new</span> ResourceManager(<span class="stringliteral">&quot;Database.Properties.Resources&quot;</span>, Assembly.GetExecutingAssembly());
<a name="l00025"></a>00025         <span class="keyword">private</span> SqlCeConnection             sqlConnection;
<a name="l00026"></a>00026         <span class="keyword">private</span> <span class="keywordtype">string</span>                      databaseName;
<a name="l00027"></a>00027         <span class="keyword">private</span> <span class="keywordtype">string</span>                      sqlConnectionString;
<a name="l00028"></a>00028         <span class="keyword">private</span> <span class="keywordtype">string</span>                      sqlQuery;
<a name="l00029"></a>00029         <span class="keyword">private</span> Dictionary&lt;string, string&gt;  sqlCommandParameters;
<a name="l00030"></a>00030         <span class="keyword">private</span> Dictionary&lt;string, string&gt;  sqlWhereParameters;
<a name="l00031"></a>00031         <span class="keyword">private</span> <span class="keywordtype">string</span> tableName;
<a name="l00032"></a>00032         
<a name="l00033"></a>00033         <span class="comment">// Define public member properties.</span>
<a name="l00034"></a>00034         <span class="keyword">public</span> <span class="keywordtype">string</span> <a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a>
<a name="l00035"></a><a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">00035</a>         {
<a name="l00036"></a>00036             <span class="keyword">get</span> { <span class="keywordflow">return</span> sqlConnectionString; }
<a name="l00037"></a>00037             <span class="keyword">set</span> { sqlConnectionString = value; }
<a name="l00038"></a>00038         }
<a name="l00039"></a>00039 
<a name="l00040"></a>00040         <span class="keyword">public</span> <span class="keywordtype">string</span> <a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a>
<a name="l00041"></a><a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">00041</a>         {
<a name="l00042"></a>00042             <span class="keyword">get</span> { <span class="keywordflow">return</span> sqlQuery; }
<a name="l00043"></a>00043             <span class="keyword">set</span> { sqlQuery = value; }
<a name="l00044"></a>00044         }
<a name="l00045"></a>00045 
<a name="l00046"></a>00046         <span class="keyword">public</span> Dictionary&lt;string, string&gt; <a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a>
<a name="l00047"></a><a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">00047</a>         {
<a name="l00048"></a>00048             <span class="keyword">get</span> { <span class="keywordflow">return</span> sqlCommandParameters; }
<a name="l00049"></a>00049             <span class="keyword">set</span> { sqlCommandParameters = value; }
<a name="l00050"></a>00050         }
<a name="l00051"></a>00051 
<a name="l00052"></a>00052         <span class="keyword">public</span> Dictionary&lt;string, string&gt; <a class="code" href="a00011.html#a88e7d214ee4e4dbc16178b575e28618f">SqlWhereParameters</a>
<a name="l00053"></a><a class="code" href="a00011.html#a88e7d214ee4e4dbc16178b575e28618f">00053</a>         {
<a name="l00054"></a>00054             <span class="keyword">get</span> { <span class="keywordflow">return</span> sqlWhereParameters; }
<a name="l00055"></a>00055             <span class="keyword">set</span> { sqlWhereParameters = value; }
<a name="l00056"></a>00056         }
<a name="l00057"></a>00057 
<a name="l00058"></a>00058         <span class="keyword">public</span> <span class="keywordtype">string</span> <a class="code" href="a00011.html#abaf38d996df6bba5f2894b63db791bb4">TableName</a>
<a name="l00059"></a><a class="code" href="a00011.html#abaf38d996df6bba5f2894b63db791bb4">00059</a>         {
<a name="l00060"></a>00060             <span class="keyword">get</span> { <span class="keywordflow">return</span> tableName; }
<a name="l00061"></a>00061             <span class="keyword">set</span> { tableName = value; }
<a name="l00062"></a>00062         }
<a name="l00063"></a>00063 
<a name="l00064"></a>00064         <span class="comment">// DatabaseType structure.</span>
<a name="l00065"></a><a class="code" href="a00001.html">00065</a>         <span class="keyword">public</span> <span class="keyword">struct </span><a class="code" href="a00001.html">DatabaseType</a>
<a name="l00066"></a>00066         {
<a name="l00067"></a><a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">00067</a>             <span class="keyword">public</span> <span class="keyword">const</span> <span class="keywordtype">string</span> <a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">MediaLibrary</a>   = <span class="stringliteral">@&quot;\data\MediaLibrary.sdf&quot;</span>;
<a name="l00068"></a><a class="code" href="a00001.html#a05364bfce69ac9f480c5d3b959a2215e">00068</a>             <span class="keyword">public</span> <span class="keyword">const</span> <span class="keywordtype">string</span> <a class="code" href="a00001.html#a05364bfce69ac9f480c5d3b959a2215e">MediaOrganizer</a> = <span class="stringliteral">@&quot;\data\MediaOrganizer.sdf&quot;</span>;
<a name="l00069"></a>00069         }
<a name="l00070"></a>00070 
<a name="l00075"></a><a class="code" href="a00011.html#ae0a810d8b32238b02c5f2beb34ce89b6">00075</a>         <span class="keyword">public</span> <a class="code" href="a00011.html#ae0a810d8b32238b02c5f2beb34ce89b6" title="Default Constructor.">SQL</a>(<span class="keywordtype">string</span> databaseType = <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">MediaLibrary</a>)
<a name="l00076"></a>00076         {
<a name="l00077"></a>00077             <span class="comment">// Set the name and path of the database.</span>
<a name="l00078"></a>00078             this.databaseName = this.<a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547" title="Returns the path from where current code is called from after it has been compiled and deployed...">GetRuntimeExecutingPath</a>() + databaseType;
<a name="l00079"></a>00079 
<a name="l00080"></a>00080             <span class="comment">// Set the name of the new database.</span>
<a name="l00081"></a>00081             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = <span class="stringliteral">@&quot;Data Source=&quot;</span> + databaseName + <span class="stringliteral">&quot;;Persist Security Info=False;Max Database Size=4000&quot;</span>;
<a name="l00082"></a>00082 
<a name="l00083"></a>00083             <span class="comment">// Initialize member properties.</span>
<a name="l00084"></a>00084             this.<a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a> = <span class="keyword">new</span> Dictionary&lt;string, string&gt;() { };
<a name="l00085"></a>00085             this.<a class="code" href="a00011.html#a88e7d214ee4e4dbc16178b575e28618f">SqlWhereParameters</a>   = <span class="keyword">new</span> Dictionary&lt;string, string&gt;() { };
<a name="l00086"></a>00086 
<a name="l00087"></a>00087             <span class="comment">// Create a Windows Event Log Source.</span>
<a name="l00088"></a>00088             <span class="keywordflow">if</span> (!EventLog.SourceExists(resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>)))
<a name="l00089"></a>00089             {
<a name="l00090"></a>00090                 EventLog.CreateEventSource(resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>), <span class="stringliteral">&quot;Application&quot;</span>);
<a name="l00091"></a>00091             }
<a name="l00092"></a>00092 
<a name="l00093"></a>00093             <span class="comment">// Create the necessary database structure if not already done.</span>
<a name="l00094"></a>00094             this.<a class="code" href="a00011.html#a6a64050f1bad4782c8bbaa3dbbc040c8" title="Initializes and creates all needed databases for this application. This method is run once when the a...">InitializeDatabases</a>(databaseType);
<a name="l00095"></a>00095         }
<a name="l00096"></a>00096 
<a name="l00103"></a><a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130">00103</a>         <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="keywordtype">string</span> tableName, <span class="keywordtype">string</span> columnName)
<a name="l00104"></a>00104         {
<a name="l00105"></a>00105             <span class="comment">// Main variables.</span>
<a name="l00106"></a>00106             DataTable databaseTableDataMediaLibrary   = <span class="keyword">new</span> DataTable();
<a name="l00107"></a>00107             DataTable databaseTableDataMediaOrganizer = <span class="keyword">new</span> DataTable();
<a name="l00108"></a>00108 
<a name="l00109"></a>00109             <span class="comment">// Save the original connection string.</span>
<a name="l00110"></a>00110             <span class="keywordtype">string</span> originalConnectionString = this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a>;
<a name="l00111"></a>00111 
<a name="l00112"></a>00112             <span class="comment">// Set the SQL query.</span>
<a name="l00113"></a>00113             <span class="keywordtype">string</span> sql = <span class="stringliteral">@&quot;</span>
<a name="l00114"></a>00114 <span class="stringliteral">                SELECT CHARACTER_MAXIMUM_LENGTH </span>
<a name="l00115"></a>00115 <span class="stringliteral">                FROM INFORMATION_SCHEMA.COLUMNS</span>
<a name="l00116"></a>00116 <span class="stringliteral">                WHERE TABLE_NAME=&#39;&quot;</span> + tableName + <span class="stringliteral">@&quot;&#39; AND COLUMN_NAME=&#39;&quot;</span> + columnName + <span class="stringliteral">@&quot;&#39;</span>
<a name="l00117"></a>00117 <span class="stringliteral">            &quot;</span>;
<a name="l00118"></a>00118 
<a name="l00119"></a>00119             <span class="comment">// Set the table name.</span>
<a name="l00120"></a>00120             this.tableName = tableName;
<a name="l00121"></a>00121 
<a name="l00122"></a>00122             <span class="comment">// Set the connection string for MediaLibrary.</span>
<a name="l00123"></a>00123             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = <span class="stringliteral">@&quot;Data Source=&quot;</span> + this.<a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547" title="Returns the path from where current code is called from after it has been compiled and deployed...">GetRuntimeExecutingPath</a>() + <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">MediaLibrary</a> + <span class="stringliteral">&quot;;Persist Security Info=False;Max Database Size=4000&quot;</span>;
<a name="l00124"></a>00124 
<a name="l00125"></a>00125             <span class="comment">// Build the SQL Query string for MediaLibrary.</span>
<a name="l00126"></a>00126             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> = sql;
<a name="l00127"></a>00127 
<a name="l00128"></a>00128             <span class="comment">// Try to retrieve the data for MediaLibrary.</span>
<a name="l00129"></a>00129             databaseTableDataMediaLibrary = this.<a class="code" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd" title="Retrieves data from a database table.">GetData</a>();
<a name="l00130"></a>00130 
<a name="l00131"></a>00131             <span class="comment">// Set the connection string for MediaOrganizer.</span>
<a name="l00132"></a>00132             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = <span class="stringliteral">@&quot;Data Source=&quot;</span> + this.<a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547" title="Returns the path from where current code is called from after it has been compiled and deployed...">GetRuntimeExecutingPath</a>() + <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a05364bfce69ac9f480c5d3b959a2215e">MediaOrganizer</a> + <span class="stringliteral">&quot;;Persist Security Info=False;Max Database Size=4000&quot;</span>;
<a name="l00133"></a>00133 
<a name="l00134"></a>00134             <span class="comment">// Build the SQL Query string for MediaOrganizer.</span>
<a name="l00135"></a>00135             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> = sql;
<a name="l00136"></a>00136 
<a name="l00137"></a>00137             <span class="comment">// Try to retrieve the data for MediaOrganizer.</span>
<a name="l00138"></a>00138             databaseTableDataMediaOrganizer = this.<a class="code" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd" title="Retrieves data from a database table.">GetData</a>();
<a name="l00139"></a>00139 
<a name="l00140"></a>00140             <span class="comment">// Restore the original connection string.</span>
<a name="l00141"></a>00141             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = originalConnectionString;
<a name="l00142"></a>00142 
<a name="l00143"></a>00143             <span class="comment">// Return the max length of the column.</span>
<a name="l00144"></a>00144             <span class="keywordflow">if</span> (databaseTableDataMediaLibrary.Rows.Count &gt; 0)
<a name="l00145"></a>00145             {
<a name="l00146"></a>00146                 <span class="keywordflow">try</span>
<a name="l00147"></a>00147                 {
<a name="l00148"></a>00148                     <span class="keywordflow">return</span> Convert.ToInt32(databaseTableDataMediaLibrary.Rows[0][0].ToString());
<a name="l00149"></a>00149                 }
<a name="l00150"></a>00150                 <span class="keywordflow">catch</span> (Exception exception)
<a name="l00151"></a>00151                 {
<a name="l00152"></a>00152                     EventLog.WriteEntry(
<a name="l00153"></a>00153                         resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>),
<a name="l00154"></a>00154                         <span class="stringliteral">@&quot;</span>
<a name="l00155"></a>00155 <span class="stringliteral">                        Class:  SQL</span>
<a name="l00156"></a>00156 <span class="stringliteral">                        Method: GetDatabaseColumnMaxLength(&quot;</span> + tableName + <span class="stringliteral">@&quot;, &quot;</span> + columnName + <span class="stringliteral">@&quot;)</span>
<a name="l00157"></a>00157 <span class="stringliteral">                        Action: Convert.ToInt32(&quot;</span> + databaseTableDataMediaLibrary.Rows[0][0].ToString() + <span class="stringliteral">@&quot;);</span>
<a name="l00158"></a>00158 <span class="stringliteral">                    </span>
<a name="l00159"></a>00159 <span class="stringliteral">                        &quot;</span> + exception.Message,
<a name="l00160"></a>00160                         EventLogEntryType.Error, 
<a name="l00161"></a>00161                         123
<a name="l00162"></a>00162                     );
<a name="l00163"></a>00163 
<a name="l00164"></a>00164                     <span class="keywordflow">return</span> -1;
<a name="l00165"></a>00165                 }
<a name="l00166"></a>00166             }
<a name="l00167"></a>00167             <span class="keywordflow">if</span> (databaseTableDataMediaOrganizer.Rows.Count &gt; 0)
<a name="l00168"></a>00168             {
<a name="l00169"></a>00169                 <span class="keywordflow">try</span>
<a name="l00170"></a>00170                 {
<a name="l00171"></a>00171                     <span class="keywordflow">return</span> Convert.ToInt32(databaseTableDataMediaOrganizer.Rows[0][0].ToString());
<a name="l00172"></a>00172                 }
<a name="l00173"></a>00173                 <span class="keywordflow">catch</span> (Exception exception)
<a name="l00174"></a>00174                 {
<a name="l00175"></a>00175                     EventLog.WriteEntry(
<a name="l00176"></a>00176                         resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>),
<a name="l00177"></a>00177                         <span class="stringliteral">@&quot;</span>
<a name="l00178"></a>00178 <span class="stringliteral">                        Class:  SQL</span>
<a name="l00179"></a>00179 <span class="stringliteral">                        Method: GetDatabaseColumnMaxLength(&quot;</span> + tableName + <span class="stringliteral">@&quot;, &quot;</span> + columnName + <span class="stringliteral">@&quot;)</span>
<a name="l00180"></a>00180 <span class="stringliteral">                        Action: Convert.ToInt32(&quot;</span> + databaseTableDataMediaOrganizer.Rows[0][0].ToString() + <span class="stringliteral">@&quot;);</span>
<a name="l00181"></a>00181 <span class="stringliteral">                    </span>
<a name="l00182"></a>00182 <span class="stringliteral">                        &quot;</span> + exception.Message,
<a name="l00183"></a>00183                         EventLogEntryType.Error, 
<a name="l00184"></a>00184                         123
<a name="l00185"></a>00185                     );
<a name="l00186"></a>00186 
<a name="l00187"></a>00187                     <span class="keywordflow">return</span> -1;
<a name="l00188"></a>00188                 }
<a name="l00189"></a>00189             }
<a name="l00190"></a>00190             <span class="comment">// Otherwise return -1.</span>
<a name="l00191"></a>00191             <span class="keywordflow">else</span>
<a name="l00192"></a>00192             {
<a name="l00193"></a>00193                 <span class="keywordflow">return</span> -1;
<a name="l00194"></a>00194             }
<a name="l00195"></a>00195         }
<a name="l00196"></a>00196 
<a name="l00203"></a><a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a">00203</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="keywordtype">string</span> tableName, <span class="keywordtype">string</span> columnName)
<a name="l00204"></a>00204         {
<a name="l00205"></a>00205             <span class="comment">// Main variables.</span>
<a name="l00206"></a>00206             DataTable databaseTableDataMediaLibrary   = <span class="keyword">new</span> DataTable();
<a name="l00207"></a>00207             DataTable databaseTableDataMediaOrganizer = <span class="keyword">new</span> DataTable();
<a name="l00208"></a>00208 
<a name="l00209"></a>00209             <span class="comment">// Save the original connection string.</span>
<a name="l00210"></a>00210             <span class="keywordtype">string</span> originalConnectionString = this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a>;
<a name="l00211"></a>00211 
<a name="l00212"></a>00212             <span class="comment">// Set the SQL query.</span>
<a name="l00213"></a>00213             <span class="keywordtype">string</span> sql = <span class="stringliteral">@&quot;</span>
<a name="l00214"></a>00214 <span class="stringliteral">                SELECT * </span>
<a name="l00215"></a>00215 <span class="stringliteral">                FROM INFORMATION_SCHEMA.COLUMNS</span>
<a name="l00216"></a>00216 <span class="stringliteral">                WHERE TABLE_NAME=&#39;&quot;</span> + tableName + <span class="stringliteral">@&quot;&#39; AND COLUMN_NAME=&#39;&quot;</span> + columnName + <span class="stringliteral">@&quot;&#39;</span>
<a name="l00217"></a>00217 <span class="stringliteral">            &quot;</span>;
<a name="l00218"></a>00218 
<a name="l00219"></a>00219             <span class="comment">// Set the table name.</span>
<a name="l00220"></a>00220             this.tableName = tableName;
<a name="l00221"></a>00221             
<a name="l00222"></a>00222             <span class="comment">// Set the connection string for MediaLibrary.</span>
<a name="l00223"></a>00223             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = <span class="stringliteral">@&quot;Data Source=&quot;</span> + this.<a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547" title="Returns the path from where current code is called from after it has been compiled and deployed...">GetRuntimeExecutingPath</a>() + <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">MediaLibrary</a> + <span class="stringliteral">&quot;;Persist Security Info=False;Max Database Size=4000&quot;</span>;
<a name="l00224"></a>00224             
<a name="l00225"></a>00225             <span class="comment">// Build the SQL Query string for MediaLibrary.</span>
<a name="l00226"></a>00226             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> = sql;
<a name="l00227"></a>00227 
<a name="l00228"></a>00228             <span class="comment">// Try to retrieve the data for MediaLibrary.</span>
<a name="l00229"></a>00229             databaseTableDataMediaLibrary = this.<a class="code" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd" title="Retrieves data from a database table.">GetData</a>();
<a name="l00230"></a>00230 
<a name="l00231"></a>00231             <span class="comment">// Set the connection string for MediaOrganizer.</span>
<a name="l00232"></a>00232             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = <span class="stringliteral">@&quot;Data Source=&quot;</span> + this.<a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547" title="Returns the path from where current code is called from after it has been compiled and deployed...">GetRuntimeExecutingPath</a>() + <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a05364bfce69ac9f480c5d3b959a2215e">MediaOrganizer</a> + <span class="stringliteral">&quot;;Persist Security Info=False;Max Database Size=4000&quot;</span>;
<a name="l00233"></a>00233 
<a name="l00234"></a>00234             <span class="comment">// Build the SQL Query string for MediaOrganizer.</span>
<a name="l00235"></a>00235             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> = sql;
<a name="l00236"></a>00236 
<a name="l00237"></a>00237             <span class="comment">// Try to retrieve the data for MediaOrganizer.</span>
<a name="l00238"></a>00238             databaseTableDataMediaOrganizer = this.<a class="code" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd" title="Retrieves data from a database table.">GetData</a>();
<a name="l00239"></a>00239 
<a name="l00240"></a>00240             <span class="comment">// Restore the original connection string.</span>
<a name="l00241"></a>00241             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = originalConnectionString;
<a name="l00242"></a>00242 
<a name="l00243"></a>00243             <span class="comment">// Return True if the column exists.</span>
<a name="l00244"></a>00244             <span class="keywordflow">if</span> ((databaseTableDataMediaLibrary.Rows.Count &gt; 0) || (databaseTableDataMediaOrganizer.Rows.Count &gt; 0))
<a name="l00245"></a>00245             {
<a name="l00246"></a>00246                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00247"></a>00247             }
<a name="l00248"></a>00248             <span class="comment">// Otherwise return False.</span>
<a name="l00249"></a>00249             <span class="keywordflow">else</span>
<a name="l00250"></a>00250             {
<a name="l00251"></a>00251                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00252"></a>00252             }
<a name="l00253"></a>00253         }
<a name="l00254"></a>00254 
<a name="l00260"></a><a class="code" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc">00260</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc" title="Checks if the database Table exists in the current database scheme.">DatabaseTableExists</a>(<span class="keywordtype">string</span> tableName)
<a name="l00261"></a>00261         {
<a name="l00262"></a>00262             <span class="comment">// Main variables.</span>
<a name="l00263"></a>00263             DataTable databaseTableDataMediaLibrary   = <span class="keyword">new</span> DataTable();
<a name="l00264"></a>00264             DataTable databaseTableDataMediaOrganizer = <span class="keyword">new</span> DataTable();
<a name="l00265"></a>00265 
<a name="l00266"></a>00266             <span class="comment">// Save the original connection string.</span>
<a name="l00267"></a>00267             <span class="keywordtype">string</span> originalConnectionString = this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a>;
<a name="l00268"></a>00268 
<a name="l00269"></a>00269             <span class="comment">// Set the SQL query.</span>
<a name="l00270"></a>00270             <span class="keywordtype">string</span> sql = <span class="stringliteral">@&quot;</span>
<a name="l00271"></a>00271 <span class="stringliteral">                SELECT * </span>
<a name="l00272"></a>00272 <span class="stringliteral">                FROM INFORMATION_SCHEMA.TABLES </span>
<a name="l00273"></a>00273 <span class="stringliteral">                WHERE TABLE_NAME=&#39;&quot;</span> + tableName + <span class="stringliteral">@&quot;&#39;</span>
<a name="l00274"></a>00274 <span class="stringliteral">            &quot;</span>;
<a name="l00275"></a>00275 
<a name="l00276"></a>00276             <span class="comment">// Set the table name.</span>
<a name="l00277"></a>00277             this.tableName = tableName;
<a name="l00278"></a>00278 
<a name="l00279"></a>00279             <span class="comment">// Set the connection string for MediaLibrary.</span>
<a name="l00280"></a>00280             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = <span class="stringliteral">@&quot;Data Source=&quot;</span> + this.<a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547" title="Returns the path from where current code is called from after it has been compiled and deployed...">GetRuntimeExecutingPath</a>() + <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">MediaLibrary</a> + <span class="stringliteral">&quot;;Persist Security Info=False;Max Database Size=4000&quot;</span>;
<a name="l00281"></a>00281 
<a name="l00282"></a>00282             <span class="comment">// Build the SQL Query string for MediaLibrary.</span>
<a name="l00283"></a>00283             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> = sql;
<a name="l00284"></a>00284 
<a name="l00285"></a>00285             <span class="comment">// Try to retrieve the data for MediaLibrary.</span>
<a name="l00286"></a>00286             databaseTableDataMediaLibrary = this.<a class="code" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd" title="Retrieves data from a database table.">GetData</a>();
<a name="l00287"></a>00287 
<a name="l00288"></a>00288             <span class="comment">// Set the connection string for MediaOrganizer.</span>
<a name="l00289"></a>00289             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = <span class="stringliteral">@&quot;Data Source=&quot;</span> + this.<a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547" title="Returns the path from where current code is called from after it has been compiled and deployed...">GetRuntimeExecutingPath</a>() + <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a05364bfce69ac9f480c5d3b959a2215e">MediaOrganizer</a> + <span class="stringliteral">&quot;;Persist Security Info=False;Max Database Size=4000&quot;</span>;
<a name="l00290"></a>00290 
<a name="l00291"></a>00291             <span class="comment">// Build the SQL Query string for MediaOrganizer.</span>
<a name="l00292"></a>00292             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> = sql;
<a name="l00293"></a>00293 
<a name="l00294"></a>00294             <span class="comment">// Try to retrieve the data for MediaOrganizer.</span>
<a name="l00295"></a>00295             databaseTableDataMediaOrganizer = this.<a class="code" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd" title="Retrieves data from a database table.">GetData</a>();
<a name="l00296"></a>00296 
<a name="l00297"></a>00297             <span class="comment">// Restore the original connection string.</span>
<a name="l00298"></a>00298             this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> = originalConnectionString;
<a name="l00299"></a>00299 
<a name="l00300"></a>00300             <span class="comment">// Return True if the table exists.</span>
<a name="l00301"></a>00301             <span class="keywordflow">if</span> ((databaseTableDataMediaLibrary.Rows.Count &gt; 0) || (databaseTableDataMediaOrganizer.Rows.Count &gt; 0))
<a name="l00302"></a>00302             {
<a name="l00303"></a>00303                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00304"></a>00304             }
<a name="l00305"></a>00305             <span class="comment">// Otherwise return False.</span>
<a name="l00306"></a>00306             <span class="keywordflow">else</span>
<a name="l00307"></a>00307             {
<a name="l00308"></a>00308                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00309"></a>00309             }
<a name="l00310"></a>00310         }
<a name="l00311"></a>00311 
<a name="l00316"></a><a class="code" href="a00011.html#ae721d4e9e35189c7e165bc3ec34e70ea">00316</a>         <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="a00011.html#ae721d4e9e35189c7e165bc3ec34e70ea" title="Drops/Deletes the Database Table.">DropDatabaseTable</a>(<span class="keywordtype">string</span> tableName)
<a name="l00317"></a>00317         {
<a name="l00318"></a>00318             <span class="comment">// Build the SQL Query string.</span>
<a name="l00319"></a>00319             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> = <span class="stringliteral">@&quot;DROP TABLE &quot;</span> + tableName + <span class="stringliteral">@&quot;&quot;</span>;
<a name="l00320"></a>00320 
<a name="l00321"></a>00321             <span class="comment">// Drop/Delete the table.</span>
<a name="l00322"></a>00322             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00323"></a>00323         }
<a name="l00324"></a>00324 
<a name="l00331"></a><a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f">00331</a>         <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>()
<a name="l00332"></a>00332         {
<a name="l00333"></a>00333             <span class="comment">// Define main variables.</span>
<a name="l00334"></a>00334             SqlCeCommand sqlCommand;
<a name="l00335"></a>00335 
<a name="l00336"></a>00336             <span class="comment">// Connect to the database.</span>
<a name="l00337"></a>00337             this.InitConnection();
<a name="l00338"></a>00338 
<a name="l00339"></a>00339             <span class="comment">// Open a new database connection.</span>
<a name="l00340"></a>00340             this.sqlConnection.Open();
<a name="l00341"></a>00341 
<a name="l00342"></a>00342             <span class="comment">// Try to insert data into a database table, and catch possible errors the method can throw.</span>
<a name="l00343"></a>00343             <span class="keywordflow">try</span>
<a name="l00344"></a>00344             {
<a name="l00345"></a>00345                 <span class="comment">// Make sure the required Sql Query string is set.</span>
<a name="l00346"></a>00346                 <span class="keywordflow">if</span> (!<span class="keywordtype">string</span>.IsNullOrEmpty(this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a>))
<a name="l00347"></a>00347                 {
<a name="l00348"></a>00348                     <span class="comment">// Create an SQL Ce Command object which we will use to execute an SQL query.</span>
<a name="l00349"></a>00349                     sqlCommand = <span class="keyword">new</span> SqlCeCommand(this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a>, this.sqlConnection);
<a name="l00350"></a>00350                 }
<a name="l00351"></a>00351                 <span class="comment">// Otherwise fail with a descriptive error.</span>
<a name="l00352"></a>00352                 <span class="keywordflow">else</span>
<a name="l00353"></a>00353                 {
<a name="l00354"></a>00354                     sqlCommand = null;
<a name="l00355"></a>00355                 }
<a name="l00356"></a>00356 
<a name="l00357"></a>00357                 <span class="comment">// Execute the SQL Command object using the above assigned query.</span>
<a name="l00358"></a>00358                 <span class="keywordflow">if</span> (sqlCommand != null)
<a name="l00359"></a>00359                 {
<a name="l00360"></a>00360                     <span class="keywordflow">try</span>
<a name="l00361"></a>00361                     {
<a name="l00362"></a>00362                         sqlCommand.ExecuteNonQuery();
<a name="l00363"></a>00363                     }
<a name="l00364"></a>00364                     <span class="keywordflow">catch</span> (Exception exception)
<a name="l00365"></a>00365                     {
<a name="l00366"></a>00366                         EventLog.WriteEntry(resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>),
<a name="l00367"></a>00367                             <span class="stringliteral">@&quot;</span>
<a name="l00368"></a>00368 <span class="stringliteral">                            Class:  SQL</span>
<a name="l00369"></a>00369 <span class="stringliteral">                            Method: ExecuteSql()</span>
<a name="l00370"></a>00370 <span class="stringliteral">                            Action: sqlCommand.ExecuteNonQuery()</span>
<a name="l00371"></a>00371 <span class="stringliteral">                            SQL:    &quot;</span> + sqlCommand.CommandText + <span class="stringliteral">@&quot;</span>
<a name="l00372"></a>00372 <span class="stringliteral">                    </span>
<a name="l00373"></a>00373 <span class="stringliteral">                            &quot;</span> + exception.Message
<a name="l00374"></a>00374                             , EventLogEntryType.Error, 123);
<a name="l00375"></a>00375                     }
<a name="l00376"></a>00376                 }
<a name="l00377"></a>00377             }
<a name="l00378"></a>00378             <span class="keywordflow">catch</span> (Exception exception)
<a name="l00379"></a>00379             {
<a name="l00380"></a>00380                 EventLog.WriteEntry(resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>),
<a name="l00381"></a>00381                     <span class="stringliteral">@&quot;</span>
<a name="l00382"></a>00382 <span class="stringliteral">                            Class:  SQL</span>
<a name="l00383"></a>00383 <span class="stringliteral">                            Method: ExecuteSql()</span>
<a name="l00384"></a>00384 <span class="stringliteral">                            Action: sqlCommand = new SqlCeCommand(&quot;&quot;&quot;</span> + this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> + <span class="stringliteral">@&quot;&quot;&quot;, &quot;&quot;&quot;</span> + this.sqlConnection.ConnectionString + <span class="stringliteral">@&quot;&quot;&quot;)</span>
<a name="l00385"></a>00385 <span class="stringliteral">                    </span>
<a name="l00386"></a>00386 <span class="stringliteral">                            &quot;</span> + exception.Message
<a name="l00387"></a>00387                     , EventLogEntryType.Error, 123);
<a name="l00388"></a>00388             }
<a name="l00389"></a>00389             <span class="comment">// Make sure we close the connection after completing the operation.</span>
<a name="l00390"></a>00390             <span class="keywordflow">finally</span>
<a name="l00391"></a>00391             {
<a name="l00392"></a>00392                 sqlConnection.Close();
<a name="l00393"></a>00393             }
<a name="l00394"></a>00394         }
<a name="l00395"></a>00395 
<a name="l00403"></a><a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547">00403</a>         <span class="keyword">public</span> <span class="keywordtype">string</span> <a class="code" href="a00011.html#aea5856de7ce427d271cc71c9e846c547" title="Returns the path from where current code is called from after it has been compiled and deployed...">GetRuntimeExecutingPath</a>()
<a name="l00404"></a>00404         {
<a name="l00405"></a>00405             <span class="comment">// Main variables.</span>
<a name="l00406"></a>00406             <span class="keywordtype">string</span> runtimeExecutingPath = <span class="stringliteral">@&quot;&quot;</span>;
<a name="l00407"></a>00407 
<a name="l00408"></a>00408             <span class="comment">// Get the current runtime executing path.</span>
<a name="l00409"></a>00409             runtimeExecutingPath = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
<a name="l00410"></a>00410 
<a name="l00411"></a>00411             <span class="comment">// Return the Runtime Executing Path.</span>
<a name="l00412"></a>00412             <span class="keywordflow">if</span> (runtimeExecutingPath.IndexOf(<span class="stringliteral">@&quot;\htdocs\cgi-bin&quot;</span>) &gt;= 0)
<a name="l00413"></a>00413             {
<a name="l00414"></a>00414                 <span class="keywordflow">return</span> runtimeExecutingPath.Substring(6, runtimeExecutingPath.IndexOf(<span class="stringliteral">@&quot;\htdocs\cgi-bin&quot;</span>) - 6);
<a name="l00415"></a>00415             }
<a name="l00416"></a>00416             <span class="keywordflow">else</span>
<a name="l00417"></a>00417             {
<a name="l00418"></a>00418                 <span class="keywordflow">return</span> runtimeExecutingPath.Substring(6);
<a name="l00419"></a>00419             }
<a name="l00420"></a>00420         }
<a name="l00421"></a>00421 
<a name="l00426"></a><a class="code" href="a00011.html#a51d603541db4f5550b044994c4c280e0">00426</a>         <span class="keyword">public</span> <span class="keywordtype">string</span> <a class="code" href="a00011.html#a51d603541db4f5550b044994c4c280e0">GetCurrentDate</a>()
<a name="l00427"></a>00427         {
<a name="l00428"></a>00428             <span class="keywordtype">string</span> year   = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00429"></a>00429             <span class="keywordtype">string</span> month  = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00430"></a>00430             <span class="keywordtype">string</span> day    = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00431"></a>00431             <span class="keywordtype">string</span> hour   = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00432"></a>00432             <span class="keywordtype">string</span> minute = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00433"></a>00433             <span class="keywordtype">string</span> second = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00434"></a>00434             <span class="keywordtype">string</span> offset = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00435"></a>00435 
<a name="l00436"></a>00436             <span class="keywordflow">if</span> (DateTimeOffset.Now.Year &lt; 10)
<a name="l00437"></a>00437             {
<a name="l00438"></a>00438                 year = <span class="stringliteral">&quot;0&quot;</span> + DateTimeOffset.Now.Year.ToString();
<a name="l00439"></a>00439             }
<a name="l00440"></a>00440             <span class="keywordflow">else</span>
<a name="l00441"></a>00441             {
<a name="l00442"></a>00442                 year = DateTimeOffset.Now.Year.ToString();
<a name="l00443"></a>00443             }
<a name="l00444"></a>00444 
<a name="l00445"></a>00445             <span class="keywordflow">if</span> (DateTimeOffset.Now.Month &lt; 10)
<a name="l00446"></a>00446             {
<a name="l00447"></a>00447                 month = <span class="stringliteral">&quot;0&quot;</span> + DateTimeOffset.Now.Month.ToString();
<a name="l00448"></a>00448             }
<a name="l00449"></a>00449             <span class="keywordflow">else</span>
<a name="l00450"></a>00450             {
<a name="l00451"></a>00451                 month = DateTimeOffset.Now.Month.ToString();
<a name="l00452"></a>00452             }
<a name="l00453"></a>00453 
<a name="l00454"></a>00454             <span class="keywordflow">if</span> (DateTimeOffset.Now.Day &lt; 10)
<a name="l00455"></a>00455             {
<a name="l00456"></a>00456                 day = <span class="stringliteral">&quot;0&quot;</span> + DateTimeOffset.Now.Day.ToString();
<a name="l00457"></a>00457             }
<a name="l00458"></a>00458             <span class="keywordflow">else</span>
<a name="l00459"></a>00459             {
<a name="l00460"></a>00460                 day = DateTimeOffset.Now.Day.ToString();
<a name="l00461"></a>00461             }
<a name="l00462"></a>00462 
<a name="l00463"></a>00463             <span class="keywordflow">if</span> (DateTimeOffset.Now.Hour &lt; 10)
<a name="l00464"></a>00464             {
<a name="l00465"></a>00465                 hour = <span class="stringliteral">&quot;0&quot;</span> + DateTimeOffset.Now.Hour.ToString();
<a name="l00466"></a>00466             }
<a name="l00467"></a>00467             <span class="keywordflow">else</span>
<a name="l00468"></a>00468             {
<a name="l00469"></a>00469                 hour = DateTimeOffset.Now.Hour.ToString();
<a name="l00470"></a>00470             }
<a name="l00471"></a>00471 
<a name="l00472"></a>00472             <span class="keywordflow">if</span> (DateTimeOffset.Now.Minute &lt; 10)
<a name="l00473"></a>00473             {
<a name="l00474"></a>00474                 minute = <span class="stringliteral">&quot;0&quot;</span> + DateTimeOffset.Now.Minute.ToString();
<a name="l00475"></a>00475             }
<a name="l00476"></a>00476             <span class="keywordflow">else</span>
<a name="l00477"></a>00477             {
<a name="l00478"></a>00478                 minute = DateTimeOffset.Now.Minute.ToString();
<a name="l00479"></a>00479             }
<a name="l00480"></a>00480 
<a name="l00481"></a>00481             <span class="keywordflow">if</span> (DateTimeOffset.Now.Second &lt; 10)
<a name="l00482"></a>00482             {
<a name="l00483"></a>00483                 second = <span class="stringliteral">&quot;0&quot;</span> + DateTimeOffset.Now.Second.ToString();
<a name="l00484"></a>00484             }
<a name="l00485"></a>00485             <span class="keywordflow">else</span>
<a name="l00486"></a>00486             {
<a name="l00487"></a>00487                 second = DateTimeOffset.Now.Second.ToString();
<a name="l00488"></a>00488             }
<a name="l00489"></a>00489 
<a name="l00490"></a>00490             <span class="keywordflow">if</span> (DateTimeOffset.Now.Offset.Hours &gt; 0)
<a name="l00491"></a>00491             {
<a name="l00492"></a>00492                 offset = <span class="stringliteral">&quot;UTC+&quot;</span> + DateTimeOffset.Now.Offset.Hours.ToString();
<a name="l00493"></a>00493             }
<a name="l00494"></a>00494             <span class="keywordflow">else</span>
<a name="l00495"></a>00495             {
<a name="l00496"></a>00496                 offset = <span class="stringliteral">&quot;UTC&quot;</span> + DateTimeOffset.Now.Offset.Hours.ToString();
<a name="l00497"></a>00497             }
<a name="l00498"></a>00498 
<a name="l00499"></a>00499             <span class="keywordflow">return</span> year + <span class="stringliteral">&quot;-&quot;</span> + month + <span class="stringliteral">&quot;-&quot;</span> + day + <span class="stringliteral">&quot; &quot;</span> + hour + <span class="stringliteral">&quot;:&quot;</span> + minute + <span class="stringliteral">&quot;:&quot;</span> + second + <span class="stringliteral">&quot; &quot;</span> + offset;
<a name="l00500"></a>00500         }
<a name="l00501"></a>00501 
<a name="l00511"></a><a class="code" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd">00511</a>         <span class="keyword">public</span> DataTable <a class="code" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd" title="Retrieves data from a database table.">GetData</a>()
<a name="l00512"></a>00512         {
<a name="l00513"></a>00513             <span class="comment">// Connect to the database.</span>
<a name="l00514"></a>00514             this.InitConnection();
<a name="l00515"></a>00515 
<a name="l00516"></a>00516             <span class="comment">// Define main variables.</span>
<a name="l00517"></a>00517             SqlCeDataAdapter sqlTableAdapter = null;
<a name="l00518"></a>00518             DataSet sqlDataSet = null;
<a name="l00519"></a>00519 
<a name="l00520"></a>00520             <span class="comment">// Open a new database connection.</span>
<a name="l00521"></a>00521             <span class="keywordflow">if</span> (sqlConnection.State == ConnectionState.Closed)
<a name="l00522"></a>00522             {
<a name="l00523"></a>00523                 this.sqlConnection.Open();
<a name="l00524"></a>00524             }
<a name="l00525"></a>00525 
<a name="l00526"></a>00526             <span class="comment">// Try to retrieve data from a database table, </span>
<a name="l00527"></a>00527             <span class="comment">// and catch possible errors the method can throw.</span>
<a name="l00528"></a>00528             <span class="keywordflow">try</span>
<a name="l00529"></a>00529             {
<a name="l00530"></a>00530                 <span class="comment">// Make sure the required SQL Query is not blank.</span>
<a name="l00531"></a>00531                 <span class="keywordflow">if</span> ((this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> != <span class="stringliteral">&quot;&quot;</span>) &amp;&amp; (this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> != null))
<a name="l00532"></a>00532                 {
<a name="l00533"></a>00533                     <span class="comment">// Create an SQL Ce Adapter object which we will use to execute an SQL query for retrieval.</span>
<a name="l00534"></a>00534                     sqlTableAdapter = <span class="keyword">new</span> SqlCeDataAdapter(this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a>, this.sqlConnection);
<a name="l00535"></a>00535                 }
<a name="l00536"></a>00536 
<a name="l00537"></a>00537                 <span class="comment">// Create an SQL DataSet object which will hold the retrieved data records.</span>
<a name="l00538"></a>00538                 sqlDataSet = <span class="keyword">new</span> DataSet();
<a name="l00539"></a>00539 
<a name="l00540"></a>00540                 <span class="comment">// Fill the DataSet with the retrieved data records,</span>
<a name="l00541"></a>00541                 <span class="comment">// and assign the DataSet to the SQL Adapter.</span>
<a name="l00542"></a>00542                 sqlTableAdapter.Fill(sqlDataSet, this.<a class="code" href="a00011.html#abaf38d996df6bba5f2894b63db791bb4">TableName</a>);
<a name="l00543"></a>00543             }
<a name="l00544"></a>00544             <span class="keywordflow">catch</span> (Exception exception)
<a name="l00545"></a>00545             {
<a name="l00546"></a>00546                 EventLog.WriteEntry(resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>),
<a name="l00547"></a>00547                     <span class="stringliteral">@&quot;</span>
<a name="l00548"></a>00548 <span class="stringliteral">                            Class:  SQL</span>
<a name="l00549"></a>00549 <span class="stringliteral">                            Method: GetData()</span>
<a name="l00550"></a>00550 <span class="stringliteral">                            Action: sqlTableAdapter.Fill(&quot;&quot;&lt;sqlDataSet&gt;&quot;&quot;, &quot;&quot;&quot;</span> + this.<a class="code" href="a00011.html#abaf38d996df6bba5f2894b63db791bb4">TableName</a> + <span class="stringliteral">@&quot;&quot;&quot;)</span>
<a name="l00551"></a>00551 <span class="stringliteral">                    </span>
<a name="l00552"></a>00552 <span class="stringliteral">                            &quot;</span> + this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> + <span class="stringliteral">@&quot;</span>
<a name="l00553"></a>00553 <span class="stringliteral">                            &quot;</span> + exception.Message
<a name="l00554"></a>00554                     , EventLogEntryType.Error, 123);
<a name="l00555"></a>00555             }
<a name="l00556"></a>00556             <span class="comment">// Make sure we close the connection after completing the operation.</span>
<a name="l00557"></a>00557             <span class="keywordflow">finally</span>
<a name="l00558"></a>00558             {
<a name="l00559"></a>00559                 sqlConnection.Close();
<a name="l00560"></a>00560             }
<a name="l00561"></a>00561 
<a name="l00562"></a>00562             <span class="comment">// Return the DataSet and all the retrieved data records.</span>
<a name="l00563"></a>00563             <span class="keywordflow">return</span> sqlDataSet.Tables[this.<a class="code" href="a00011.html#abaf38d996df6bba5f2894b63db791bb4">TableName</a>];
<a name="l00564"></a>00564         }
<a name="l00565"></a>00565 
<a name="l00573"></a>00573         <span class="keyword">private</span> <span class="keywordtype">void</span> InitConnection()
<a name="l00574"></a>00574         {
<a name="l00575"></a>00575             <span class="comment">// Build the connection as long as the connection string has been set.</span>
<a name="l00576"></a>00576             <span class="keywordflow">if</span> ((this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> != <span class="stringliteral">&quot;&quot;</span>) &amp;&amp; (this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a> != null))
<a name="l00577"></a>00577             {
<a name="l00578"></a>00578                 this.sqlConnection = <span class="keyword">new</span> SqlCeConnection(this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a>);
<a name="l00579"></a>00579             }
<a name="l00580"></a>00580         }
<a name="l00581"></a>00581 
<a name="l00587"></a><a class="code" href="a00011.html#a6a64050f1bad4782c8bbaa3dbbc040c8">00587</a>         <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="a00011.html#a6a64050f1bad4782c8bbaa3dbbc040c8" title="Initializes and creates all needed databases for this application. This method is run once when the a...">InitializeDatabases</a>(<span class="keywordtype">string</span> databaseType = <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">MediaLibrary</a>)
<a name="l00588"></a>00588         {
<a name="l00589"></a>00589             <span class="comment">// Define main variables.</span>
<a name="l00590"></a>00590             SqlCeEngine  sqlEngine;
<a name="l00591"></a>00591 
<a name="l00592"></a>00592             <span class="comment">// Try to create the new database, and catch possible errors the method can throw.</span>
<a name="l00593"></a>00593             <span class="keywordflow">if</span> (!File.Exists(<span class="keyword">this</span>.databaseName))
<a name="l00594"></a>00594             {
<a name="l00595"></a>00595                 <span class="comment">// Build an SQL Ce Engine using the above data source string.</span>
<a name="l00596"></a>00596                 <span class="comment">// The Engine object will be used later to create the new database.</span>
<a name="l00597"></a>00597                 sqlEngine = <span class="keyword">new</span> SqlCeEngine(this.<a class="code" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a>);
<a name="l00598"></a>00598 
<a name="l00599"></a>00599                 <span class="keywordflow">try</span>
<a name="l00600"></a>00600                 {
<a name="l00601"></a>00601                     <span class="comment">// Create the database.</span>
<a name="l00602"></a>00602                     sqlEngine.CreateDatabase();
<a name="l00603"></a>00603                 }
<a name="l00604"></a>00604                 <span class="keywordflow">catch</span> (Exception exception)
<a name="l00605"></a>00605                 {
<a name="l00606"></a>00606                     EventLog.WriteEntry(resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>),
<a name="l00607"></a>00607                         <span class="stringliteral">@&quot;</span>
<a name="l00608"></a>00608 <span class="stringliteral">                            Class:  SQL</span>
<a name="l00609"></a>00609 <span class="stringliteral">                            Method: InitializeDatabases()</span>
<a name="l00610"></a>00610 <span class="stringliteral">                            Action: sqlEngine.CreateDatabase()</span>
<a name="l00611"></a>00611 <span class="stringliteral">                    </span>
<a name="l00612"></a>00612 <span class="stringliteral">                            &quot;</span> + exception.Message
<a name="l00613"></a>00613                         , EventLogEntryType.Error, 123);
<a name="l00614"></a>00614                 }
<a name="l00615"></a>00615             }
<a name="l00616"></a>00616 
<a name="l00617"></a>00617             <span class="comment">// Try to create a new table in the new database, and catch possible errors the method can throw.</span>
<a name="l00618"></a>00618             <span class="keywordflow">if</span> (File.Exists(<span class="keyword">this</span>.databaseName))
<a name="l00619"></a>00619             {
<a name="l00620"></a>00620                 <span class="keywordflow">try</span>
<a name="l00621"></a>00621                 {
<a name="l00622"></a>00622                     <span class="comment">// Create a Test Table to use for Unit Testing.</span>
<a name="l00623"></a>00623                     <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc" title="Checks if the database Table exists in the current database scheme.">DatabaseTableExists</a>(<span class="stringliteral">@&quot;test&quot;</span>))
<a name="l00624"></a>00624                     {
<a name="l00625"></a>00625                         this.sqlQuery = <span class="stringliteral">@&quot;</span>
<a name="l00626"></a>00626 <span class="stringliteral">                        CREATE TABLE test (</span>
<a name="l00627"></a>00627 <span class="stringliteral">                            id int NOT NULL IDENTITY (1, 1), </span>
<a name="l00628"></a>00628 <span class="stringliteral">                            unique_id uniqueidentifier, </span>
<a name="l00629"></a>00629 <span class="stringliteral">                            title nvarchar(256) NOT NULL, </span>
<a name="l00630"></a>00630 <span class="stringliteral">                            media_type nvarchar(256), </span>
<a name="l00631"></a>00631 <span class="stringliteral">                            PRIMARY KEY (id), </span>
<a name="l00632"></a>00632 <span class="stringliteral">                            UNIQUE (id)</span>
<a name="l00633"></a>00633 <span class="stringliteral">                        )</span>
<a name="l00634"></a>00634 <span class="stringliteral">                        &quot;</span>;
<a name="l00635"></a>00635 
<a name="l00636"></a>00636                         this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00637"></a>00637                     }
<a name="l00638"></a>00638 
<a name="l00639"></a>00639                     <span class="keywordflow">if</span> (databaseType == <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a05364bfce69ac9f480c5d3b959a2215e">MediaOrganizer</a>)
<a name="l00640"></a>00640                     {
<a name="l00641"></a>00641                         <span class="comment">// Create the Synchronizer Status Table.</span>
<a name="l00642"></a>00642                         <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc" title="Checks if the database Table exists in the current database scheme.">DatabaseTableExists</a>(<span class="stringliteral">@&quot;sync_status&quot;</span>))
<a name="l00643"></a>00643                         {
<a name="l00644"></a>00644                             this.sqlQuery = <span class="stringliteral">@&quot;</span>
<a name="l00645"></a>00645 <span class="stringliteral">                            CREATE TABLE sync_status (</span>
<a name="l00646"></a>00646 <span class="stringliteral">                                pkid uniqueidentifier NOT NULL DEFAULT NEWID(), </span>
<a name="l00647"></a>00647 <span class="stringliteral">                                id int NOT NULL IDENTITY (1, 1), </span>
<a name="l00648"></a>00648 <span class="stringliteral">                                job_id uniqueidentifier NOT NULL, </span>
<a name="l00649"></a>00649 <span class="stringliteral">                                date nvarchar(50) NOT NULL, </span>
<a name="l00650"></a>00650 <span class="stringliteral">                                directory nvarchar(256) NOT NULL, </span>
<a name="l00651"></a>00651 <span class="stringliteral">                                action nvarchar(4000) NOT NULL,</span>
<a name="l00652"></a>00652 <span class="stringliteral">                                PRIMARY KEY (pkid), </span>
<a name="l00653"></a>00653 <span class="stringliteral">                                UNIQUE (pkid)</span>
<a name="l00654"></a>00654 <span class="stringliteral">                            )</span>
<a name="l00655"></a>00655 <span class="stringliteral">                            &quot;</span>;
<a name="l00656"></a>00656 
<a name="l00657"></a>00657                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00658"></a>00658                         }
<a name="l00659"></a>00659 
<a name="l00660"></a>00660                         <span class="comment">// Create the Disabled Movie Details Table.</span>
<a name="l00661"></a>00661                         <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc" title="Checks if the database Table exists in the current database scheme.">DatabaseTableExists</a>(<span class="stringliteral">@&quot;disabled_movie_details&quot;</span>))
<a name="l00662"></a>00662                         {
<a name="l00663"></a>00663                             this.sqlQuery = <span class="stringliteral">@&quot;</span>
<a name="l00664"></a>00664 <span class="stringliteral">                            CREATE TABLE disabled_movie_details (</span>
<a name="l00665"></a>00665 <span class="stringliteral">                                pkid uniqueidentifier NOT NULL DEFAULT NEWID(), </span>
<a name="l00666"></a>00666 <span class="stringliteral">                                id int NOT NULL IDENTITY (1, 1), </span>
<a name="l00667"></a>00667 <span class="stringliteral">                                path nvarchar(256) NOT NULL, </span>
<a name="l00668"></a>00668 <span class="stringliteral">                                filename nvarchar(256), </span>
<a name="l00669"></a>00669 <span class="stringliteral">                                PRIMARY KEY (pkid), </span>
<a name="l00670"></a>00670 <span class="stringliteral">                                UNIQUE (pkid)</span>
<a name="l00671"></a>00671 <span class="stringliteral">                            )</span>
<a name="l00672"></a>00672 <span class="stringliteral">                            &quot;</span>;
<a name="l00673"></a>00673 
<a name="l00674"></a>00674                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00675"></a>00675                         }
<a name="l00676"></a>00676                     }
<a name="l00677"></a>00677                     <span class="keywordflow">else</span> <span class="keywordflow">if</span> (databaseType == <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">MediaLibrary</a>)
<a name="l00678"></a>00678                     {
<a name="l00679"></a>00679                         <span class="comment">// Create the Audio Table.</span>
<a name="l00680"></a>00680                         <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc" title="Checks if the database Table exists in the current database scheme.">DatabaseTableExists</a>(<span class="stringliteral">@&quot;audio&quot;</span>))
<a name="l00681"></a>00681                         {
<a name="l00682"></a>00682                             this.sqlQuery = <span class="stringliteral">@&quot;</span>
<a name="l00683"></a>00683 <span class="stringliteral">                            CREATE TABLE audio (</span>
<a name="l00684"></a>00684 <span class="stringliteral">                                pkid uniqueidentifier NOT NULL DEFAULT NEWID(), </span>
<a name="l00685"></a>00685 <span class="stringliteral">                                id int NOT NULL IDENTITY (1, 1), </span>
<a name="l00686"></a>00686 <span class="stringliteral">                                unique_id uniqueidentifier NOT NULL, </span>
<a name="l00687"></a>00687 <span class="stringliteral">                                filename nvarchar(256) NOT NULL, </span>
<a name="l00688"></a>00688 <span class="stringliteral">                                path nvarchar(256) NOT NULL, </span>
<a name="l00689"></a>00689 <span class="stringliteral">                                file_type nvarchar(4) NOT NULL, </span>
<a name="l00690"></a>00690 <span class="stringliteral">                                file_size nvarchar(25), </span>
<a name="l00691"></a>00691 <span class="stringliteral">                                duration nvarchar(25),</span>
<a name="l00692"></a>00692 <span class="stringliteral">                                audio nvarchar (256), </span>
<a name="l00693"></a>00693 <span class="stringliteral">                                cover image,</span>
<a name="l00694"></a>00694 <span class="stringliteral">                                artist nvarchar(256), </span>
<a name="l00695"></a>00695 <span class="stringliteral">                                track nvarchar(256), </span>
<a name="l00696"></a>00696 <span class="stringliteral">                                album nvarchar(256), </span>
<a name="l00697"></a>00697 <span class="stringliteral">                                genre nvarchar(256), </span>
<a name="l00698"></a>00698 <span class="stringliteral">                                release_year nvarchar(25), </span>
<a name="l00699"></a>00699 <span class="stringliteral">                                tag nvarchar(256),</span>
<a name="l00700"></a>00700 <span class="stringliteral">                                completed int DEFAULT 0,</span>
<a name="l00701"></a>00701 <span class="stringliteral">                                last_played_date nvarchar(50),</span>
<a name="l00702"></a>00702 <span class="stringliteral">                                last_played_duration int DEFAULT 0,</span>
<a name="l00703"></a>00703 <span class="stringliteral">                                nr_of_times_played int DEFAULT 0,</span>
<a name="l00704"></a>00704 <span class="stringliteral">                                PRIMARY KEY (pkid), </span>
<a name="l00705"></a>00705 <span class="stringliteral">                                UNIQUE (pkid)</span>
<a name="l00706"></a>00706 <span class="stringliteral">                            )</span>
<a name="l00707"></a>00707 <span class="stringliteral">                            &quot;</span>;
<a name="l00708"></a>00708 
<a name="l00709"></a>00709                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00710"></a>00710 
<a name="l00711"></a>00711                             <span class="comment">// Create an ascending sorted index for the filename column.</span>
<a name="l00712"></a>00712                             <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;audio&quot;</span>, <span class="stringliteral">@&quot;filename&quot;</span>))
<a name="l00713"></a>00713                             {
<a name="l00714"></a>00714                                 this.sqlQuery = <span class="stringliteral">@&quot;CREATE INDEX idx_audio_filename_SortAscending ON audio (filename ASC)&quot;</span>;
<a name="l00715"></a>00715                                 this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00716"></a>00716                             }
<a name="l00717"></a>00717 
<a name="l00718"></a>00718                             <span class="comment">// Create an ascending sorted index for the path column.</span>
<a name="l00719"></a>00719                             <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;audio&quot;</span>, <span class="stringliteral">@&quot;path&quot;</span>))
<a name="l00720"></a>00720                             {
<a name="l00721"></a>00721                                 this.sqlQuery = <span class="stringliteral">@&quot;CREATE INDEX idx_audio_path_SortAscending ON audio (path ASC)&quot;</span>;
<a name="l00722"></a>00722                                 this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00723"></a>00723                             }
<a name="l00724"></a>00724                         }
<a name="l00725"></a>00725 
<a name="l00726"></a>00726                         <span class="comment">// Create the Pictures Table.</span>
<a name="l00727"></a>00727                         <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc" title="Checks if the database Table exists in the current database scheme.">DatabaseTableExists</a>(<span class="stringliteral">@&quot;pictures&quot;</span>))
<a name="l00728"></a>00728                         {
<a name="l00729"></a>00729                             this.sqlQuery = <span class="stringliteral">@&quot;</span>
<a name="l00730"></a>00730 <span class="stringliteral">                            CREATE TABLE pictures (</span>
<a name="l00731"></a>00731 <span class="stringliteral">                                pkid uniqueidentifier NOT NULL DEFAULT NEWID(), </span>
<a name="l00732"></a>00732 <span class="stringliteral">                                id int NOT NULL IDENTITY (1, 1), </span>
<a name="l00733"></a>00733 <span class="stringliteral">                                unique_id uniqueidentifier NOT NULL, </span>
<a name="l00734"></a>00734 <span class="stringliteral">                                filename nvarchar(256) NOT NULL, </span>
<a name="l00735"></a>00735 <span class="stringliteral">                                path nvarchar(256) NOT NULL, </span>
<a name="l00736"></a>00736 <span class="stringliteral">                                file_type nvarchar(4) NOT NULL, </span>
<a name="l00737"></a>00737 <span class="stringliteral">                                file_size nvarchar(25), </span>
<a name="l00738"></a>00738 <span class="stringliteral">                                dimensions nvarchar(25),</span>
<a name="l00739"></a>00739 <span class="stringliteral">                                comment nvarchar(4000),</span>
<a name="l00740"></a>00740 <span class="stringliteral">                                tag nvarchar(256),</span>
<a name="l00741"></a>00741 <span class="stringliteral">                                last_played_date nvarchar(50),</span>
<a name="l00742"></a>00742 <span class="stringliteral">                                nr_of_times_played int DEFAULT 0,</span>
<a name="l00743"></a>00743 <span class="stringliteral">                                PRIMARY KEY (pkid), </span>
<a name="l00744"></a>00744 <span class="stringliteral">                                UNIQUE (pkid)</span>
<a name="l00745"></a>00745 <span class="stringliteral">                            )</span>
<a name="l00746"></a>00746 <span class="stringliteral">                            &quot;</span>;
<a name="l00747"></a>00747 
<a name="l00748"></a>00748                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00749"></a>00749 
<a name="l00750"></a>00750                             <span class="comment">// Create an ascending sorted index for the filename column.</span>
<a name="l00751"></a>00751                             <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;pictures&quot;</span>, <span class="stringliteral">@&quot;filename&quot;</span>))
<a name="l00752"></a>00752                             {
<a name="l00753"></a>00753                                 this.sqlQuery = <span class="stringliteral">@&quot;CREATE INDEX idx_pictures_filename_SortAscending ON pictures (filename ASC)&quot;</span>;
<a name="l00754"></a>00754                                 this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00755"></a>00755                             }
<a name="l00756"></a>00756 
<a name="l00757"></a>00757                             <span class="comment">// Create an ascending sorted index for the path column.</span>
<a name="l00758"></a>00758                             <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;pictures&quot;</span>, <span class="stringliteral">@&quot;path&quot;</span>))
<a name="l00759"></a>00759                             {
<a name="l00760"></a>00760                                 this.sqlQuery = <span class="stringliteral">@&quot;CREATE INDEX idx_pictures_path_SortAscending ON pictures (path ASC)&quot;</span>;
<a name="l00761"></a>00761                                 this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00762"></a>00762                             }
<a name="l00763"></a>00763                         }
<a name="l00764"></a>00764 
<a name="l00765"></a>00765                         <span class="comment">// Create the Videos Table.</span>
<a name="l00766"></a>00766                         <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc" title="Checks if the database Table exists in the current database scheme.">DatabaseTableExists</a>(<span class="stringliteral">@&quot;videos&quot;</span>))
<a name="l00767"></a>00767                         {
<a name="l00768"></a>00768                             this.sqlQuery = <span class="stringliteral">@&quot;</span>
<a name="l00769"></a>00769 <span class="stringliteral">                            CREATE TABLE videos (</span>
<a name="l00770"></a>00770 <span class="stringliteral">                                pkid uniqueidentifier NOT NULL DEFAULT NEWID(), </span>
<a name="l00771"></a>00771 <span class="stringliteral">                                id int NOT NULL IDENTITY (1, 1), </span>
<a name="l00772"></a>00772 <span class="stringliteral">                                unique_id uniqueidentifier NOT NULL, </span>
<a name="l00773"></a>00773 <span class="stringliteral">                                filename nvarchar(256) NOT NULL, </span>
<a name="l00774"></a>00774 <span class="stringliteral">                                path nvarchar(256) NOT NULL, </span>
<a name="l00775"></a>00775 <span class="stringliteral">                                file_type nvarchar(4) NOT NULL, </span>
<a name="l00776"></a>00776 <span class="stringliteral">                                file_size nvarchar(25), </span>
<a name="l00777"></a>00777 <span class="stringliteral">                                duration nvarchar(25), </span>
<a name="l00778"></a>00778 <span class="stringliteral">                                audio nvarchar(256),</span>
<a name="l00779"></a>00779 <span class="stringliteral">                                video nvarchar(256),</span>
<a name="l00780"></a>00780 <span class="stringliteral">                                tag nvarchar(256),</span>
<a name="l00781"></a>00781 <span class="stringliteral">                                completed int DEFAULT 0,</span>
<a name="l00782"></a>00782 <span class="stringliteral">                                last_played_date nvarchar(50),</span>
<a name="l00783"></a>00783 <span class="stringliteral">                                last_played_duration int DEFAULT 0,</span>
<a name="l00784"></a>00784 <span class="stringliteral">                                nr_of_times_played int DEFAULT 0,</span>
<a name="l00785"></a>00785 <span class="stringliteral">                                movie_details_id nvarchar(25),</span>
<a name="l00786"></a>00786 <span class="stringliteral">                                movie_details_backdrop nvarchar(256),</span>
<a name="l00787"></a>00787 <span class="stringliteral">                                movie_details_cast nvarchar(1024),</span>
<a name="l00788"></a>00788 <span class="stringliteral">                                movie_details_cover nvarchar(256),</span>
<a name="l00789"></a>00789 <span class="stringliteral">                                movie_details_director nvarchar(256),</span>
<a name="l00790"></a>00790 <span class="stringliteral">                                movie_details_genre nvarchar(256),</span>
<a name="l00791"></a>00791 <span class="stringliteral">                                movie_details_name nvarchar(256),</span>
<a name="l00792"></a>00792 <span class="stringliteral">                                movie_details_released nvarchar(25),</span>
<a name="l00793"></a>00793 <span class="stringliteral">                                movie_details_summary nvarchar(4000),</span>
<a name="l00794"></a>00794 <span class="stringliteral">                                movie_details_trailer nvarchar(1024),</span>
<a name="l00795"></a>00795 <span class="stringliteral">                                movie_details_writers nvarchar(1024),</span>
<a name="l00796"></a>00796 <span class="stringliteral">                                episode_details_airdate nvarchar(25),</span>
<a name="l00797"></a>00797 <span class="stringliteral">                                episode_details_cast nvarchar(1024),</span>
<a name="l00798"></a>00798 <span class="stringliteral">                                episode_details_cover nvarchar(256),</span>
<a name="l00799"></a>00799 <span class="stringliteral">                                episode_details_director nvarchar(256),</span>
<a name="l00800"></a>00800 <span class="stringliteral">                                episode_details_genre nvarchar(256),</span>
<a name="l00801"></a>00801 <span class="stringliteral">                                episode_details_name nvarchar(256),</span>
<a name="l00802"></a>00802 <span class="stringliteral">                                episode_details_next_airdate nvarchar(25),</span>
<a name="l00803"></a>00803 <span class="stringliteral">                                episode_details_next_number nvarchar(25),</span>
<a name="l00804"></a>00804 <span class="stringliteral">                                episode_details_next_title nvarchar(256),</span>
<a name="l00805"></a>00805 <span class="stringliteral">                                episode_details_number nvarchar(25),</span>
<a name="l00806"></a>00806 <span class="stringliteral">                                episode_details_summary nvarchar(4000),</span>
<a name="l00807"></a>00807 <span class="stringliteral">                                episode_details_title nvarchar(256),</span>
<a name="l00808"></a>00808 <span class="stringliteral">                                episode_details_writers nvarchar(1024),</span>
<a name="l00809"></a>00809 <span class="stringliteral">                                PRIMARY KEY (pkid), </span>
<a name="l00810"></a>00810 <span class="stringliteral">                                UNIQUE (pkid)</span>
<a name="l00811"></a>00811 <span class="stringliteral">                            )</span>
<a name="l00812"></a>00812 <span class="stringliteral">                            &quot;</span>;
<a name="l00813"></a>00813 
<a name="l00814"></a>00814                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00815"></a>00815 
<a name="l00816"></a>00816                             <span class="comment">// Create an ascending sorted index for the filename column.</span>
<a name="l00817"></a>00817                             <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;filename&quot;</span>))
<a name="l00818"></a>00818                             {
<a name="l00819"></a>00819                                 this.sqlQuery = <span class="stringliteral">@&quot;CREATE INDEX idx_videos_filename_SortAscending ON videos (filename ASC)&quot;</span>;
<a name="l00820"></a>00820                                 this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00821"></a>00821                             }
<a name="l00822"></a>00822 
<a name="l00823"></a>00823                             <span class="comment">// Create an ascending sorted index for the path column.</span>
<a name="l00824"></a>00824                             <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;path&quot;</span>))
<a name="l00825"></a>00825                             {
<a name="l00826"></a>00826                                 this.sqlQuery = <span class="stringliteral">@&quot;CREATE INDEX idx_videos_path_SortAscending ON videos (path ASC)&quot;</span>;
<a name="l00827"></a>00827                                 this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00828"></a>00828                             }
<a name="l00829"></a>00829                         }
<a name="l00830"></a>00830                     }
<a name="l00831"></a>00831                 }
<a name="l00832"></a>00832                 <span class="keywordflow">catch</span> (Exception exception)
<a name="l00833"></a>00833                 {
<a name="l00834"></a>00834                     EventLog.WriteEntry(resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>),
<a name="l00835"></a>00835                         <span class="stringliteral">@&quot;</span>
<a name="l00836"></a>00836 <span class="stringliteral">                            Class:  SQL</span>
<a name="l00837"></a>00837 <span class="stringliteral">                            Method: InitializeDatabases()</span>
<a name="l00838"></a>00838 <span class="stringliteral">                            Action: Creating default tables and indexes.</span>
<a name="l00839"></a>00839 <span class="stringliteral">                    </span>
<a name="l00840"></a>00840 <span class="stringliteral">                            &quot;</span> + exception.Message
<a name="l00841"></a>00841                         , EventLogEntryType.Error, 123);
<a name="l00842"></a>00842                 }
<a name="l00843"></a>00843                 <span class="comment">// Make sure we close the connection after completing the operation.</span>
<a name="l00844"></a>00844                 <span class="keywordflow">finally</span>
<a name="l00845"></a>00845                 {
<a name="l00846"></a>00846                     sqlConnection.Close();
<a name="l00847"></a>00847                 }
<a name="l00848"></a>00848 
<a name="l00849"></a>00849                 <span class="keywordflow">try</span>
<a name="l00850"></a>00850                 {
<a name="l00851"></a>00851                     <span class="comment">// Alter the table structures.</span>
<a name="l00852"></a>00852                     <span class="keywordflow">if</span> (databaseType == <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a05364bfce69ac9f480c5d3b959a2215e">MediaOrganizer</a>)
<a name="l00853"></a>00853                     {
<a name="l00854"></a>00854                         <span class="comment">// Change the action column from varbinary to nvarchar.</span>
<a name="l00855"></a>00855                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;sync_status&quot;</span>, <span class="stringliteral">@&quot;action&quot;</span>) &gt; 4000)
<a name="l00856"></a>00856                         {
<a name="l00857"></a>00857                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE sync_status ALTER COLUMN action nvarchar(4000)&quot;</span>;
<a name="l00858"></a>00858                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00859"></a>00859                         }
<a name="l00860"></a>00860                     }
<a name="l00861"></a>00861 
<a name="l00862"></a>00862                     <span class="comment">// Alter the table structures.</span>
<a name="l00863"></a>00863                     <span class="keywordflow">if</span> (databaseType == <a class="code" href="a00001.html">DatabaseType</a>.<a class="code" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">MediaLibrary</a>)
<a name="l00864"></a>00864                     {
<a name="l00865"></a>00865                         <span class="comment">// Extend the max characters of the file_type column.</span>
<a name="l00866"></a>00866                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;audio&quot;</span>, <span class="stringliteral">@&quot;file_type&quot;</span>) &lt; 4)
<a name="l00867"></a>00867                         {
<a name="l00868"></a>00868                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE audio ALTER COLUMN file_type nvarchar(4) NOT NULL&quot;</span>;
<a name="l00869"></a>00869                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00870"></a>00870                         }
<a name="l00871"></a>00871 
<a name="l00872"></a>00872                         <span class="comment">// Extend the max characters of the file_type column.</span>
<a name="l00873"></a>00873                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;pictures&quot;</span>, <span class="stringliteral">@&quot;file_type&quot;</span>) &lt; 4)
<a name="l00874"></a>00874                         {
<a name="l00875"></a>00875                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE pictures ALTER COLUMN file_type nvarchar(4) NOT NULL&quot;</span>;
<a name="l00876"></a>00876                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00877"></a>00877                         }
<a name="l00878"></a>00878 
<a name="l00879"></a>00879                         <span class="comment">// Change the comment column from varbinary to nvarchar.</span>
<a name="l00880"></a>00880                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;pictures&quot;</span>, <span class="stringliteral">@&quot;comment&quot;</span>) &gt; 4000)
<a name="l00881"></a>00881                         {
<a name="l00882"></a>00882                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE pictures ALTER COLUMN comment nvarchar(4000)&quot;</span>;
<a name="l00883"></a>00883                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00884"></a>00884                         }
<a name="l00885"></a>00885 
<a name="l00886"></a>00886                         <span class="comment">// Extend the max characters of the file_type column.</span>
<a name="l00887"></a>00887                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;file_type&quot;</span>) &lt; 4)
<a name="l00888"></a>00888                         {
<a name="l00889"></a>00889                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE videos ALTER COLUMN file_type nvarchar(4) NOT NULL&quot;</span>;
<a name="l00890"></a>00890                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00891"></a>00891                         }
<a name="l00892"></a>00892                         
<a name="l00893"></a>00893                         <span class="comment">// Extend the max characters of the movie_details_writers column.</span>
<a name="l00894"></a>00894                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;movie_details_writers&quot;</span>) &lt; 1024)
<a name="l00895"></a>00895                         {
<a name="l00896"></a>00896                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE videos ALTER COLUMN movie_details_writers nvarchar(1024)&quot;</span>;
<a name="l00897"></a>00897                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00898"></a>00898                         }
<a name="l00899"></a>00899 
<a name="l00900"></a>00900                         <span class="comment">// Extend the max characters of the episode_details_writers column.</span>
<a name="l00901"></a>00901                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;episode_details_writers&quot;</span>) &lt; 1024)
<a name="l00902"></a>00902                         {
<a name="l00903"></a>00903                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE videos ALTER COLUMN episode_details_writers nvarchar(1024)&quot;</span>;
<a name="l00904"></a>00904                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00905"></a>00905                         }
<a name="l00906"></a>00906                         
<a name="l00907"></a>00907                         <span class="comment">// Change the movie_details_summary column from varbinary to nvarchar.</span>
<a name="l00908"></a>00908                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;movie_details_summary&quot;</span>) &gt; 4000)
<a name="l00909"></a>00909                         {
<a name="l00910"></a>00910                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE videos ALTER COLUMN movie_details_summary nvarchar(4000)&quot;</span>;
<a name="l00911"></a>00911                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00912"></a>00912                         }
<a name="l00913"></a>00913 
<a name="l00914"></a>00914                         <span class="comment">// Change the episode_details_summary column from varbinary to nvarchar.</span>
<a name="l00915"></a>00915                         <span class="keywordflow">if</span> (this.<a class="code" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130" title="Returns the max length of the database table column.">GetDatabaseColumnMaxLength</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;episode_details_summary&quot;</span>) &gt; 4000)
<a name="l00916"></a>00916                         {
<a name="l00917"></a>00917                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE videos ALTER COLUMN episode_details_summary nvarchar(4000)&quot;</span>;
<a name="l00918"></a>00918                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00919"></a>00919                         }
<a name="l00920"></a>00920                         
<a name="l00921"></a>00921                         <span class="comment">// Add a movie_details_cast column.</span>
<a name="l00922"></a>00922                         <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;movie_details_cast&quot;</span>))
<a name="l00923"></a>00923                         {
<a name="l00924"></a>00924                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE videos ADD movie_details_cast nvarchar(1024)&quot;</span>;
<a name="l00925"></a>00925                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00926"></a>00926                         }
<a name="l00927"></a>00927 
<a name="l00928"></a>00928                         <span class="comment">// Add an episode_details_cast column.</span>
<a name="l00929"></a>00929                         <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;episode_details_cast&quot;</span>))
<a name="l00930"></a>00930                         {
<a name="l00931"></a>00931                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE videos ADD episode_details_cast nvarchar(1024)&quot;</span>;
<a name="l00932"></a>00932                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00933"></a>00933                         }
<a name="l00934"></a>00934 
<a name="l00935"></a>00935                         <span class="comment">// Add a movie_details_trailer column.</span>
<a name="l00936"></a>00936                         <span class="keywordflow">if</span> (!this.<a class="code" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a" title="Checks if the database table Column exists in the current database scheme.">DatabaseColumnExists</a>(<span class="stringliteral">@&quot;videos&quot;</span>, <span class="stringliteral">@&quot;movie_details_trailer&quot;</span>))
<a name="l00937"></a>00937                         {
<a name="l00938"></a>00938                             this.sqlQuery = <span class="stringliteral">@&quot;ALTER TABLE videos ADD movie_details_trailer nvarchar(1024)&quot;</span>;
<a name="l00939"></a>00939                             this.<a class="code" href="a00011.html#a705ece1690cc64ce559151e17979109f" title="Executes the SQL Command.">ExecuteSql</a>();
<a name="l00940"></a>00940                         }
<a name="l00941"></a>00941                     }
<a name="l00942"></a>00942                 }
<a name="l00943"></a>00943                 <span class="keywordflow">catch</span> (Exception exception)
<a name="l00944"></a>00944                 {
<a name="l00945"></a>00945                     EventLog.WriteEntry(resourceManager.GetString(<span class="stringliteral">&quot;application_title&quot;</span>),
<a name="l00946"></a>00946                         <span class="stringliteral">@&quot;</span>
<a name="l00947"></a>00947 <span class="stringliteral">                            Class:  SQL</span>
<a name="l00948"></a>00948 <span class="stringliteral">                            Method: InitializeDatabases()</span>
<a name="l00949"></a>00949 <span class="stringliteral">                            Action: Altering the table structure.</span>
<a name="l00950"></a>00950 <span class="stringliteral">                    </span>
<a name="l00951"></a>00951 <span class="stringliteral">                            &quot;</span> + exception.Message
<a name="l00952"></a>00952                         , EventLogEntryType.Error, 123);
<a name="l00953"></a>00953                 }
<a name="l00954"></a>00954                 <span class="comment">// Make sure we close the connection after completing the operation.</span>
<a name="l00955"></a>00955                 <span class="keywordflow">finally</span>
<a name="l00956"></a>00956                 {
<a name="l00957"></a>00957                     sqlConnection.Close();
<a name="l00958"></a>00958                 }
<a name="l00959"></a>00959             }
<a name="l00960"></a>00960         }
<a name="l00961"></a>00961 
<a name="l00969"></a><a class="code" href="a00011.html#a8549a029a9a289473ca168328aa6d619">00969</a>         <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="a00011.html#a8549a029a9a289473ca168328aa6d619" title="Inserts data into a database table.">InsertData</a>()
<a name="l00970"></a>00970         {
<a name="l00971"></a>00971             <span class="comment">// Connect to the database.</span>
<a name="l00972"></a>00972             this.InitConnection();
<a name="l00973"></a>00973 
<a name="l00974"></a>00974             <span class="comment">// Define main variables.</span>
<a name="l00975"></a>00975             SqlCeCommand sqlCommand;
<a name="l00976"></a>00976 
<a name="l00977"></a>00977             <span class="comment">// Open a new database connection.</span>
<a name="l00978"></a>00978             <span class="keywordflow">if</span> (sqlConnection.State == ConnectionState.Closed)
<a name="l00979"></a>00979             {
<a name="l00980"></a>00980                 this.sqlConnection.Open();
<a name="l00981"></a>00981             }
<a name="l00982"></a>00982 
<a name="l00983"></a>00983             <span class="comment">// Try to insert data into a database table, </span>
<a name="l00984"></a>00984             <span class="comment">// and catch possible errors the method can throw.</span>
<a name="l00985"></a>00985             <span class="keywordflow">try</span>
<a name="l00986"></a>00986             {
<a name="l00987"></a>00987                 <span class="comment">// Make sure the required Sql Command Parameters and Table Name are set.</span>
<a name="l00988"></a>00988                 <span class="keywordflow">if</span> (
<a name="l00989"></a>00989                     (this.<a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a> != null) &amp;&amp; 
<a name="l00990"></a>00990                     (this.<a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a>.Count &gt; 0) &amp;&amp; 
<a name="l00991"></a>00991                     (!<span class="keywordtype">string</span>.IsNullOrEmpty(<span class="keyword">this</span>.TableName))
<a name="l00992"></a>00992                 )
<a name="l00993"></a>00993                 {
<a name="l00994"></a>00994                     <span class="comment">// Build the SQL Query.</span>
<a name="l00995"></a>00995                     <span class="comment">// Final SQL query will some something like: &quot;INSERT INTO table_name (col1, col2) VALUES (@col1, @col2)&quot;.</span>
<a name="l00996"></a>00996                     <span class="comment">// And at the end the parameters @col1 and @col2 will be replaced with &#39;val1&#39; and &#39;val2&#39;.</span>
<a name="l00997"></a>00997                     this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> = <span class="stringliteral">@&quot;INSERT INTO &quot;</span> + this.<a class="code" href="a00011.html#abaf38d996df6bba5f2894b63db791bb4">TableName</a> + <span class="stringliteral">@&quot; (&quot;</span>;
<a name="l00998"></a>00998 
<a name="l00999"></a>00999                     <span class="comment">// Initialize the loop counter.</span>
<a name="l01000"></a>01000                     <span class="keywordtype">int</span> loopCounter = 0;
<a name="l01001"></a>01001 
<a name="l01002"></a>01002                     <span class="comment">// Build the table column key part of the SQL query.</span>
<a name="l01003"></a>01003                     <span class="keywordflow">foreach</span> (<span class="keywordtype">string</span> key <span class="keywordflow">in</span> this.<a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a>.Keys)
<a name="l01004"></a>01004                     {
<a name="l01005"></a>01005                         <span class="keywordflow">if</span> (loopCounter != <a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a>.Keys.Count - 1)
<a name="l01006"></a>01006                         {
<a name="l01007"></a>01007                             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> += key + <span class="stringliteral">@&quot;, &quot;</span>;
<a name="l01008"></a>01008                         }
<a name="l01009"></a>01009                         <span class="keywordflow">else</span>
<a name="l01010"></a>01010                         {
<a name="l01011"></a>01011                             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> += key;
<a name="l01012"></a>01012                         }
<a name="l01013"></a>01013 
<a name="l01014"></a>01014                         loopCounter++;
<a name="l01015"></a>01015                     }
<a name="l01016"></a>01016 
<a name="l01017"></a>01017                     this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> += <span class="stringliteral">@&quot;) VALUES (&quot;</span>;
<a name="l01018"></a>01018 
<a name="l01019"></a>01019                     loopCounter = 0;
<a name="l01020"></a>01020 
<a name="l01021"></a>01021                     <span class="comment">// Build the table column value part of the SQL query.</span>
<a name="l01022"></a>01022                     <span class="keywordflow">foreach</span> (<span class="keywordtype">string</span> key <span class="keywordflow">in</span> this.<a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a>.Keys)
<a name="l01023"></a>01023                     {
<a name="l01024"></a>01024                         <span class="keywordflow">if</span> (loopCounter != <a class="code" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a>.Keys.Count - 1)
<a name="l01025"></a>01025                         {
<a name="l01026"></a>01026                             this.<a class="code" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a> += <span class="stringliteral">@&quot;</span><span class="stringliteral">@&quot; + key + @&quot;</span>, &quot;;
<a name="l01027"></a>01027                         }
<a name="l01028"></a>01028                         else
<a name="l01029"></a>01029                         {
<a name="l01030"></a>01030                             this.SqlQuery += @&quot;<span class="stringliteral">@&quot; + key;</span>
<a name="l01031"></a>01031 <span class="stringliteral">                        }</span>
<a name="l01032"></a>01032 <span class="stringliteral"></span>
<a name="l01033"></a>01033 <span class="stringliteral">                        loopCounter++;</span>
<a name="l01034"></a>01034 <span class="stringliteral">                    }</span>
<a name="l01035"></a>01035 <span class="stringliteral"></span>
<a name="l01036"></a>01036 <span class="stringliteral">                    this.SqlQuery += @&quot;</span>)&quot;;
<a name="l01037"></a>01037 
<a name="l01038"></a>01038                     // Create an SQL Ce Command object which we will use to execute an SQL query.
<a name="l01039"></a>01039                     sqlCommand = new SqlCeCommand(this.SqlQuery, this.sqlConnection);
<a name="l01040"></a>01040 
<a name="l01041"></a>01041                     // Replace @-parameters in the query with actual values.
<a name="l01042"></a>01042                     foreach (KeyValuePair&lt;string, string&gt; parameter in this.SqlCommandParameters)
<a name="l01043"></a>01043                     {
<a name="l01044"></a>01044                         try
<a name="l01045"></a>01045                         {
<a name="l01046"></a>01046                             /*
<a name="l01047"></a>01047                             if (
<a name="l01048"></a>01048                                 (parameter.Key == @&quot;cover&quot;) ||
<a name="l01049"></a>01049                                 (parameter.Key == @&quot;movie_details_summary&quot;) || 
<a name="l01050"></a>01050                                 (parameter.Key == @&quot;episode_details_summary&quot;) || 
<a name="l01051"></a>01051                                 (parameter.Key == @&quot;comment&quot;) || 
<a name="l01052"></a>01052                                 (parameter.Key == @&quot;action&quot;)
<a name="l01053"></a>01053                             )
<a name="l01054"></a>01054                             */
<a name="l01055"></a>01055                             if (parameter.Key == @&quot;cover&quot;)
<a name="l01056"></a>01056                             {
<a name="l01057"></a>01057                                 sqlCommand.Parameters.AddWithValue(@&quot;<span class="stringliteral">@&quot; + parameter.Key, System.Text.UnicodeEncoding.Unicode.GetBytes(parameter.Value));</span>
<a name="l01058"></a>01058 <span class="stringliteral">                            }</span>
<a name="l01059"></a>01059 <span class="stringliteral">                            else</span>
<a name="l01060"></a>01060 <span class="stringliteral">                            {</span>
<a name="l01061"></a>01061 <span class="stringliteral">                                sqlCommand.Parameters.AddWithValue(@&quot;</span><span class="stringliteral">@&quot; + parameter.Key, parameter.Value);</span>
<a name="l01062"></a>01062 <span class="stringliteral">                            }</span>
<a name="l01063"></a>01063 <span class="stringliteral">                        }</span>
<a name="l01064"></a>01064 <span class="stringliteral">                        catch (Exception exception)</span>
<a name="l01065"></a>01065 <span class="stringliteral">                        {</span>
<a name="l01066"></a>01066 <span class="stringliteral">                            EventLog.WriteEntry(resourceManager.GetString(&quot;</span>application_title&quot;),
<a name="l01067"></a>01067                                 @&quot;
<a name="l01068"></a>01068                                 Class:  SQL
<a name="l01069"></a>01069                                 Method: InsertData()
<a name="l01070"></a>01070                                 Action: sqlCommand.Parameters.AddWithValue(&quot;&quot;&quot; + parameter.Key + @&quot;&quot;&quot;, &quot;&quot;&quot; + parameter.Value + @&quot;&quot;&quot;)
<a name="l01071"></a>01071                     
<a name="l01072"></a>01072                                 &quot; + exception.Message
<a name="l01073"></a>01073                                 , EventLogEntryType.Error, 123);
<a name="l01074"></a>01074                         }
<a name="l01075"></a>01075                     }
<a name="l01076"></a>01076                 }
<a name="l01077"></a>01077                 // Otherwise fail with a descriptive error.
<a name="l01078"></a>01078                 else
<a name="l01079"></a>01079                 {
<a name="l01080"></a>01080                     sqlCommand = null;
<a name="l01081"></a>01081                 }
<a name="l01082"></a>01082 
<a name="l01083"></a>01083                 // Execute the SQL Command object using the above assigned query.
<a name="l01084"></a>01084                 if (sqlCommand != null)
<a name="l01085"></a>01085                 {
<a name="l01086"></a>01086                     try
<a name="l01087"></a>01087                     {
<a name="l01088"></a>01088                         //Console.WriteLine(sqlCommand.CommandText);
<a name="l01089"></a>01089                         sqlCommand.ExecuteNonQuery();
<a name="l01090"></a>01090                     }
<a name="l01091"></a>01091                     catch (Exception exception)
<a name="l01092"></a>01092                     {
<a name="l01093"></a>01093                         EventLog.WriteEntry(resourceManager.GetString(&quot;application_title&quot;),
<a name="l01094"></a>01094                             @&quot;
<a name="l01095"></a>01095                             Class:  SQL
<a name="l01096"></a>01096                             Method: InsertData()
<a name="l01097"></a>01097                             Action: sqlCommand.ExecuteNonQuery()
<a name="l01098"></a>01098                             SQL: &quot; + sqlCommand.CommandText + @&quot;
<a name="l01099"></a>01099                             
<a name="l01100"></a>01100                             &quot; + exception.Message
<a name="l01101"></a>01101                             , EventLogEntryType.Error, 123);
<a name="l01102"></a>01102                     }
<a name="l01103"></a>01103                 }
<a name="l01104"></a>01104             }
<a name="l01105"></a>01105             catch (Exception exception)
<a name="l01106"></a>01106             {
<a name="l01107"></a>01107                 EventLog.WriteEntry(resourceManager.GetString(&quot;application_title&quot;),
<a name="l01108"></a>01108                     @&quot;
<a name="l01109"></a>01109                     Class:  SQL
<a name="l01110"></a>01110                     Method: InsertData()
<a name="l01111"></a>01111                     Action: Insert record into database table.
<a name="l01112"></a>01112                     
<a name="l01113"></a>01113                     &quot; + exception.Message
<a name="l01114"></a>01114                     , EventLogEntryType.Error, 123);
<a name="l01115"></a>01115             }
<a name="l01116"></a>01116             // Make sure we close the connection after completing the operation.
<a name="l01117"></a>01117             finally
<a name="l01118"></a>01118             {
<a name="l01119"></a>01119                 sqlConnection.Close();
<a name="l01120"></a>01120             }
<a name="l01121"></a>01121         }
<a name="l01122"></a>01122 
<a name="l01132"></a><a class="code" href="a00011.html#acb1dc0d1b304d3a7efd843fb327ef5f3">01132</a>         public void UpdateData(bool whereSearch = false)
<a name="l01133"></a>01133         {
<a name="l01134"></a>01134             // Connect to the database.
<a name="l01135"></a>01135             this.InitConnection();
<a name="l01136"></a>01136 
<a name="l01137"></a>01137             // Define main variables.
<a name="l01138"></a>01138             SqlCeCommand sqlCommand;
<a name="l01139"></a>01139 
<a name="l01140"></a>01140             // Open a new database connection.
<a name="l01141"></a>01141             if (sqlConnection.State == ConnectionState.Closed)
<a name="l01142"></a>01142             {
<a name="l01143"></a>01143                 this.sqlConnection.Open();
<a name="l01144"></a>01144             }
<a name="l01145"></a>01145 
<a name="l01146"></a>01146             // Try to insert data into a database table, 
<a name="l01147"></a>01147             // and catch possible errors the method can throw.
<a name="l01148"></a>01148             try
<a name="l01149"></a>01149             {
<a name="l01150"></a>01150                 // Make sure the required Sql Command Parameters and Table Name are set.
<a name="l01151"></a>01151                 if (
<a name="l01152"></a>01152                     (this.SqlCommandParameters != null) &amp;&amp;
<a name="l01153"></a>01153                     (this.SqlCommandParameters.Count &gt; 0) &amp;&amp;
<a name="l01154"></a>01154                     (!string.IsNullOrEmpty(this.TableName))
<a name="l01155"></a>01155                 )
<a name="l01156"></a>01156                 {
<a name="l01157"></a>01157                     // Build the SQL Query.
<a name="l01158"></a>01158                     // Final SQL query will be some something like: &quot;UPDATE table_name col1=@col1, col2=@col2 WHERE col0=@col0&quot;.
<a name="l01159"></a>01159                     // And at the end the parameters @col1 and @col2 will be replaced with &#39;val1&#39; and &#39;val2&#39; etc.
<a name="l01160"></a>01160                     this.SqlQuery = @&quot;UPDATE &quot; + this.TableName + @&quot; SET &quot;;
<a name="l01161"></a>01161 
<a name="l01162"></a>01162                     // Initialize the loop counter.
<a name="l01163"></a>01163                     int loopCounter = 0;
<a name="l01164"></a>01164 
<a name="l01165"></a>01165                     // Build the table column key part of the SQL query.
<a name="l01166"></a>01166                     foreach (string key in this.SqlCommandParameters.Keys)
<a name="l01167"></a>01167                     {
<a name="l01168"></a>01168                         if (loopCounter != SqlCommandParameters.Keys.Count - 1)
<a name="l01169"></a>01169                         {
<a name="l01170"></a>01170                             this.SqlQuery += key + @&quot;=@&quot; + key + @&quot;, &quot;;
<a name="l01171"></a>01171                         }
<a name="l01172"></a>01172                         else
<a name="l01173"></a>01173                         {
<a name="l01174"></a>01174                             this.SqlQuery += key + @&quot;=@&quot; + key;
<a name="l01175"></a>01175                         }
<a name="l01176"></a>01176 
<a name="l01177"></a>01177                         loopCounter++;
<a name="l01178"></a>01178                     }
<a name="l01179"></a>01179 
<a name="l01180"></a>01180                     this.SqlQuery += @&quot; WHERE &quot;;
<a name="l01181"></a>01181 
<a name="l01182"></a>01182                     // Initialize the loop counter.
<a name="l01183"></a>01183                     loopCounter = 0;
<a name="l01184"></a>01184 
<a name="l01185"></a>01185                     // Filter which keys and values will be updated using a WHERE clause.
<a name="l01186"></a>01186                     foreach (string key in this.SqlWhereParameters.Keys)
<a name="l01187"></a>01187                     {
<a name="l01188"></a>01188                         if (loopCounter != SqlWhereParameters.Keys.Count - 1)
<a name="l01189"></a>01189                         {
<a name="l01190"></a>01190                             if (whereSearch)
<a name="l01191"></a>01191                             {
<a name="l01192"></a>01192                                 this.SqlQuery += key.Replace(@&quot;where_&quot;, &quot;&quot;) + @&quot; LIKE @&quot; + key + @&quot; AND &quot;;
<a name="l01193"></a>01193                             }
<a name="l01194"></a>01194                             else
<a name="l01195"></a>01195                             {
<a name="l01196"></a>01196                                 this.SqlQuery += key.Replace(@&quot;where_&quot;, &quot;&quot;) + @&quot;=@&quot; + key + @&quot; AND &quot;;
<a name="l01197"></a>01197                             }
<a name="l01198"></a>01198                         }
<a name="l01199"></a>01199                         else
<a name="l01200"></a>01200                         {
<a name="l01201"></a>01201                             if (whereSearch)
<a name="l01202"></a>01202                             {
<a name="l01203"></a>01203                                 this.SqlQuery += key.Replace(@&quot;where_&quot;, &quot;&quot;) + @&quot; LIKE @&quot; + key + @&quot;&quot;;
<a name="l01204"></a>01204                             }
<a name="l01205"></a>01205                             else
<a name="l01206"></a>01206                             {
<a name="l01207"></a>01207                                 this.SqlQuery += key.Replace(@&quot;where_&quot;, &quot;&quot;) + @&quot;=@&quot; + key + @&quot;&quot;;
<a name="l01208"></a>01208                             }
<a name="l01209"></a>01209                         }
<a name="l01210"></a>01210 
<a name="l01211"></a>01211                         loopCounter++;
<a name="l01212"></a>01212                     }
<a name="l01213"></a>01213 
<a name="l01214"></a>01214                     // Create an SQL Ce Command object which we will use to execute an SQL query.
<a name="l01215"></a>01215                     sqlCommand = new SqlCeCommand(this.SqlQuery, this.sqlConnection);
<a name="l01216"></a>01216 
<a name="l01217"></a>01217                     // Replace @-parameters in the query with actual values.
<a name="l01218"></a>01218                     foreach (KeyValuePair&lt;string, string&gt; parameter in this.SqlCommandParameters)
<a name="l01219"></a>01219                     {
<a name="l01220"></a>01220                         try
<a name="l01221"></a>01221                         {
<a name="l01222"></a>01222                             /*
<a name="l01223"></a>01223                             if (
<a name="l01224"></a>01224                                 (parameter.Key == @&quot;cover&quot;) ||
<a name="l01225"></a>01225                                 (parameter.Key == @&quot;movie_details_summary&quot;) ||
<a name="l01226"></a>01226                                 (parameter.Key == @&quot;episode_details_summary&quot;) ||
<a name="l01227"></a>01227                                 (parameter.Key == @&quot;comment&quot;) ||
<a name="l01228"></a>01228                                 (parameter.Key == @&quot;action&quot;)
<a name="l01229"></a>01229                             )
<a name="l01230"></a>01230                             */
<a name="l01231"></a>01231                             if (parameter.Key == @&quot;cover&quot;)
<a name="l01232"></a>01232                             {
<a name="l01233"></a>01233                                 sqlCommand.Parameters.AddWithValue(@&quot;<span class="stringliteral">@&quot; + parameter.Key, System.Text.UnicodeEncoding.Unicode.GetBytes(parameter.Value));</span>
<a name="l01234"></a>01234 <span class="stringliteral">                            }</span>
<a name="l01235"></a>01235 <span class="stringliteral">                            else</span>
<a name="l01236"></a>01236 <span class="stringliteral">                            {</span>
<a name="l01237"></a>01237 <span class="stringliteral">                                sqlCommand.Parameters.AddWithValue(@&quot;</span><span class="stringliteral">@&quot; + parameter.Key, parameter.Value);</span>
<a name="l01238"></a>01238 <span class="stringliteral">                            }</span>
<a name="l01239"></a>01239 <span class="stringliteral">                        }</span>
<a name="l01240"></a>01240 <span class="stringliteral">                        catch (Exception exception)</span>
<a name="l01241"></a>01241 <span class="stringliteral">                        {</span>
<a name="l01242"></a>01242 <span class="stringliteral">                            EventLog.WriteEntry(resourceManager.GetString(&quot;</span>application_title&quot;),
<a name="l01243"></a>01243                                 @&quot;
<a name="l01244"></a>01244                                 Class:  SQL
<a name="l01245"></a>01245                                 Method: UpdateData()
<a name="l01246"></a>01246                                 Action: sqlCommand.Parameters.AddWithValue(&quot;&quot;&quot; + parameter.Key + @&quot;&quot;&quot;, &quot;&quot;&quot; + parameter.Value + @&quot;&quot;&quot;)
<a name="l01247"></a>01247                     
<a name="l01248"></a>01248                                 &quot; + exception.Message
<a name="l01249"></a>01249                                 , EventLogEntryType.Error, 123);
<a name="l01250"></a>01250                         }
<a name="l01251"></a>01251                     }
<a name="l01252"></a>01252                     
<a name="l01253"></a>01253                     // Replace @-parameters in the WHERE clause with actual values.
<a name="l01254"></a>01254                     foreach (KeyValuePair&lt;string, string&gt; parameter in this.SqlWhereParameters)
<a name="l01255"></a>01255                     {
<a name="l01256"></a>01256                         try
<a name="l01257"></a>01257                         {
<a name="l01258"></a>01258                             if (whereSearch)
<a name="l01259"></a>01259                             {
<a name="l01260"></a>01260                                 sqlCommand.Parameters.AddWithValue(@&quot;<span class="stringliteral">@&quot; + parameter.Key, @&quot;</span>%&quot; + parameter.Value + @&quot;%&quot;);
<a name="l01261"></a>01261                             }
<a name="l01262"></a>01262                             else
<a name="l01263"></a>01263                             {
<a name="l01264"></a>01264                                 sqlCommand.Parameters.AddWithValue(@&quot;<span class="stringliteral">@&quot; + parameter.Key, parameter.Value);</span>
<a name="l01265"></a>01265 <span class="stringliteral">                            }</span>
<a name="l01266"></a>01266 <span class="stringliteral">                        }</span>
<a name="l01267"></a>01267 <span class="stringliteral">                        catch (Exception exception)</span>
<a name="l01268"></a>01268 <span class="stringliteral">                        {</span>
<a name="l01269"></a>01269 <span class="stringliteral">                            EventLog.WriteEntry(resourceManager.GetString(&quot;</span>application_title&quot;),
<a name="l01270"></a>01270                                 @&quot;
<a name="l01271"></a>01271                                 Class:  SQL
<a name="l01272"></a>01272                                 Method: UpdateData()
<a name="l01273"></a>01273                                 Action: sqlCommand.Parameters.AddWithValue(&quot;&quot;&quot; + parameter.Key + @&quot;&quot;&quot;, &quot;&quot;&quot; + parameter.Value + @&quot;&quot;&quot;)
<a name="l01274"></a>01274                     
<a name="l01275"></a>01275                                 &quot; + exception.Message
<a name="l01276"></a>01276                                 , EventLogEntryType.Error, 123);
<a name="l01277"></a>01277                         }
<a name="l01278"></a>01278                     }
<a name="l01279"></a>01279                 }
<a name="l01280"></a>01280                 else
<a name="l01281"></a>01281                 {
<a name="l01282"></a>01282                     sqlCommand = null;
<a name="l01283"></a>01283                 }
<a name="l01284"></a>01284 
<a name="l01285"></a>01285                 // Execute the SQL Command object using the above assigned query.
<a name="l01286"></a>01286                 if (sqlCommand != null)
<a name="l01287"></a>01287                 {
<a name="l01288"></a>01288                     try
<a name="l01289"></a>01289                     {
<a name="l01290"></a>01290                         sqlCommand.ExecuteNonQuery();
<a name="l01291"></a>01291                     }
<a name="l01292"></a>01292                     catch (Exception exception)
<a name="l01293"></a>01293                     {
<a name="l01294"></a>01294                         EventLog.WriteEntry(resourceManager.GetString(&quot;application_title&quot;),
<a name="l01295"></a>01295                             @&quot;
<a name="l01296"></a>01296                             Class:  SQL
<a name="l01297"></a>01297                             Method: UpdateData()
<a name="l01298"></a>01298                             Action: sqlCommand.ExecuteNonQuery()
<a name="l01299"></a>01299                             SQL: &quot; + sqlCommand.CommandText + @&quot;
<a name="l01300"></a>01300                     
<a name="l01301"></a>01301                             &quot; + exception.Message
<a name="l01302"></a>01302                             , EventLogEntryType.Error, 123);
<a name="l01303"></a>01303                     }
<a name="l01304"></a>01304                 }
<a name="l01305"></a>01305             }
<a name="l01306"></a>01306             catch (Exception exception)
<a name="l01307"></a>01307             {
<a name="l01308"></a>01308                 EventLog.WriteEntry(resourceManager.GetString(&quot;application_title&quot;),
<a name="l01309"></a>01309                     @&quot;
<a name="l01310"></a>01310                     Class:  SQL
<a name="l01311"></a>01311                     Method: UpdateData()
<a name="l01312"></a>01312                     Action: Updating existing record in the database table.
<a name="l01313"></a>01313                     
<a name="l01314"></a>01314                     &quot; + exception.Message
<a name="l01315"></a>01315                     , EventLogEntryType.Error, 123);
<a name="l01316"></a>01316             }
<a name="l01317"></a>01317             // Make sure we close the connection after completing the operation.
<a name="l01318"></a>01318             finally
<a name="l01319"></a>01319             {
<a name="l01320"></a>01320                 sqlConnection.Close();
<a name="l01321"></a>01321             }
<a name="l01322"></a>01322         }
<a name="l01323"></a>01323 
<a name="l01331"></a><a class="code" href="a00011.html#a3552e211fc1fdceceb9845f163eb7bbd">01331</a>         public void DeleteData(string primaryKeyId)
<a name="l01332"></a>01332         {
<a name="l01333"></a>01333             // Make sure the table name and the primary key ID is set.
<a name="l01334"></a>01334             if (!string.IsNullOrEmpty(this.TableName) &amp;&amp; !string.IsNullOrEmpty(primaryKeyId))
<a name="l01335"></a>01335             {
<a name="l01336"></a>01336                 // Build the SQL Query.
<a name="l01337"></a>01337                 this.SqlQuery = @&quot;DELETE FROM &quot; + this.TableName + @&quot; WHERE pkid = &#39;&quot; + primaryKeyId + @&quot;&#39;&quot;;
<a name="l01338"></a>01338 
<a name="l01339"></a>01339                 // Execute the SQL Query.
<a name="l01340"></a>01340                 this.ExecuteSql();
<a name="l01341"></a>01341             }
<a name="l01342"></a>01342         }
<a name="l01343"></a>01343 
<a name="l01344"></a>01344     }
<a name="l01345"></a>01345 }
</pre></div></div><!-- contents -->
</div>
  <div id="nav-path" class="navpath">
    <ul>
      <li class="navelem"><a class="el" href="a00012.html">Database.cs</a>      </li>

    <li class="footer">Generated on Thu Jan 10 2013 07:05:17 for Voya Media by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.0 </li>
   </ul>
 </div>


</body>
</html>
